#1
|
|||
|
|||
Creating Wizards with Input Variables
I have a spreadsheet that uses numerous input variables which may start as a default value and then be changed based on the actual conditions. I have differentiated the input cells as a color to allow for them to be cleared, however, I find that on a sheet by sheet basis, it is easy to miss the inputs. I am trying to create a series of input wizards that allow for an orderly input of data. the program operates in VBA. The code does not run until the data is entered. Can someone point me to an input that allows the inputting of integers, dates, strings etc.
|
#2
|
|||
|
|||
You can create a user form for every sheet, form that apears to user when selecting the sheet, like in picture attached.. But the best approach depends on the ammount of information that the user must enter. If there are just a few entries, it's easier to use application.inputbox.
You better upload a sample workbook, indicating what fields you need in every sheet, you will get faster answers... |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and replace using variables | jago25_98 | Word | 1 | 01-31-2012 04:30 AM |
Nesting Variables SET, LISTNUM, and REF | Wyskers | Word | 1 | 11-13-2011 05:43 AM |
changing variables in MS word - please help | McGinzo | Word | 0 | 08-24-2011 06:25 AM |
Creating A Input Or Output Field | skoz55 | Excel | 0 | 08-15-2009 04:40 PM |
Envelopes with Document Variables | mailtobln | Word | 0 | 02-11-2009 10:48 PM |