User Form - use of single form for multiple sheets
Not sure why that would be a problem.
If you have one form you can load it from any sheet with:
Load Form1
Form1.Show
etc.
You could do it from a button in the sheet or you could make a toolbar menu.
RBS
"Roger on Excel" wrote in message
...
I have 10 sheets which contain identical tables for entering a chemical
process.
I use user forms for data entry, and would like to set up a single form
for
use on each sheet.
I want to use a single form that can be activated on each sheet and will
enter data on the active sheet.
I dont want to have to recreate an individual user form for each of the
identical sheets but rather use a single form that will enter data for the
specific sheet the userform is activated.
Can anyone help with relevant the code to do this?
Thanks,
Roger
|