Whatever code that closes form2, should contain code to close forms 1 and 3.

--
Regards,
Tom Ogilvy

"gregork" wrote in message
...
Thanks Flemming. Do you know how I could get all three forms to close when
I
close form 2 ?

Regards
gregork

"Flemming Dahl" wrote in message
...
Hi

You missed the "vbModeless" after Show

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

Cheers,
Flemming



"gregork" wrote in message
...
Thanks for the reply Bob. I put this code in..........

Private Sub CommandButton3_Click()
UserForm2.Show vbmodeless
UserForm10.Show vbmodeless
UserForm11.Show vbmodeless
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