Thanks for the reply Bob. I put this code in..........

Private Sub CommandButton3_Click()
UserForm2.Show
UserForm10.Show
UserForm11.Show
End Sub

.........and each userform will only show after I close the first one. I have
set the properties so they are all in different places on the sheet but I
can't get them to show all at the same time? By the way user form 2 is the
form I want to be active the other forms show data related to selections in
form 2. Where am I going wrong?

Many Thanks
gregork
"Bob Phillips" wrote in message
...
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