Two Userforms

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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