I am aware that you can produce multiple instances of the same form in VB6,
but can this be achieved in Excel vba.

I need to enter the contents of numerous vehicles at our warehouse, the
problem is we have to work 3 vehicles at a time, throughout the day. The
safest way, i believe is to produce a UserForm and enter the data on this to
then populate a database.
Do I have to have say three separate forms with the same code in each
UserForm.

Your advise would be appreciated
Regards
Lee