Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Userform data to different sheets
I have a large userform which records various pieces of information about
projects. Each project has a number of uniyts on it, each of which can have different parameters. To stop the userform becoming too large with too many options on it, i would like to be able to click a command button which would then direct the selections to a new sheet. All the cell references would stay the same. In short i am looking to 're-use' the userform. The issue i have is that i set the control source within the properties window for each textbox, dropdown etc, but to achieve what i want, i would need them to all update at once with the new sheet name before the cell reference. Incidentally, is this something i should really be doing in Access? Any help is greatly appreciated -- Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sending two sheets on one e-mail | Excel Discussion (Misc queries) | |||
userform that add data in all w/sheets | Excel Discussion (Misc queries) | |||
Sending sheets in workbook | Excel Discussion (Misc queries) | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Sending user selected daa from cmblistbx to sheets of destination | Excel Programming |