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