You can have as many as you like, but the latest one is the only one that
can be active, unless ....

As long as you have XL2000 up, make the calling form modeless
(Userform2.show vbmodeless) and then you can switch between.

Also, take a look at Chip's page as you will probably want to set the form
position so that they start not overlaying each other
http://www.cpearson.com/excel/FormPosition.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gregork" wrote in message
...
Hi,
This may sound a little strange but is it possible to have 3 user forms
showing on a sheet at the same time?
If yes then how can I do it?

Regards
gregork