|
|
#2
11-11-2012, 09:43 AM
|
|||
|
|||
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 |
Windows Vista 
Office 2010 32bit
Threaded Mode