One Question On Multipage Form

NeedsHelp2

New Member
Joined
Nov 20, 2005
Messages
22
How do I set the default so that when the spreadsheet is opened it automatically opens the multipage at page 5?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Like this?

Code:
Private Sub UserForm_Initialize()
    MultiPage1.Value = 4
End Sub

The MultiPage Index is zero based.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,129
Messages
5,576,267
Members
412,710
Latest member
Maged elmasry
Top