RB is correct that you can use the same form for different sheets. But be
careful/

While you can call the form for any sheet, your code behind the form that
sends the data entered by the user to the worksheet needs to be written so
that the data goes to the correct sheet. If no particular sheet is
specified, i.e.

Range("A4") = myControl.Value

It will post to the ActiveSheet. So make sure the active sheet is the one
you want to post to.

"Roger on Excel" wrote:

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