Hi, I hope all are well,
I am developing a workbook that opens with a small 'splash screen'
containing version number and contact details. When that Userform closes I
want to open a new Userform containing some Command Tools, e.g. comboboxes.

Is it possible to have two userforms open in this manner and if so can
anyone post sample code?

Mickey

Private Sub workbook_Open()
Userform1.Show
Userform2.Show
End Sub



--
Regards,
Tom Ogilvy

"MBlake" wrote in message
...
Hi, I hope all are well,
I am developing a workbook that opens with a small 'splash screen'
containing version number and contact details. When that Userform closes
I
want to open a new Userform containing some Command Tools, e.g.
comboboxes.

Is it possible to have two userforms open in this manner and if so can
anyone post sample code?

Mickey

Cheers Tom,
I hadn't realised it would be so obvious. I appreciate your help,

Mickey

As long as the first is shown modally (which is the default and it should
be), the second show command won't execute until the first form is unloaded
or hidden.

--
Regards,
Tom Ogilvy

"MBlake" wrote in message
...
Cheers Tom,
I hadn't realised it would be so obvious. I appreciate your help,

Mickey

Thanks Tom,
I have just tried it out and it works a treat. I thought 2 userforms would
be overkill but it works well and will suit the audience it is aimed at.

Mickey