Excel First

Excel Solutions

Tips

now browsing by category

Excel Solutions

 

Excel User Form Assistant

Force users to type in Text Boxes only what you expect…

Excel User Forms are a great way to collect data in a specific structure. Unfortunately, there is a major limitation that you have to take into consideration when choosing between a worksheet form or a User Form:  if utilizing a User Form for data entry, there is no built-in data validation for Text Boxes, or Combo Boxes… (you can only limit the number of characters, which might not be what you want)

The solution is quite simple:

To see how the solution works, download the test workbook: Real Time user form assistant.xlsm

Read More

Use Excel to populate PDF Form Fields

Did you ever need to fill out multiple PDF forms faster and without mistakes?  I’m sure that, if you’ve done this manually, on regular basis, you agree that it is tedious and time consuming.

Update:

If you have Adobe Acrobat Pro installed, then you can use an Excel App to Fill Out PDF Forms automatically, directly from Excel. Read the article and download the tool from here: excel-app-to-fill-out-pdf-forms

If you don’t have Acrobat Pro, then continue reading this page for an alternative method.

Read More