Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Userforms
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Userforms
Cheers Tom,
I hadn't realised it would be so obvious. I appreciate your help, Mickey |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Userforms
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Userforms
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Userforms | Excel Discussion (Misc queries) | |||
I need some help with userforms | Charts and Charting in Excel | |||
userforms | Excel Programming | |||
userforms | Excel Programming | |||
Userforms..... | Excel Programming |