MutiPage control question
This should get you close:
Option Explicit
Private Sub UserForm_Initialize()
Me.MultiPage1.Value = 3
End Sub
But the first page is 0, so you might want .value = 2.
(I wasn't sure how you were starting your count.)
You may want to change the (Name) property for that page to Income, then you
could use:
Option Explicit
Private Sub UserForm_Initialize()
With Me.MultiPage1
.Value = .Pages("Income").Index
End With
End Sub
And not worry about if that page ever changes position.
Patrick Simonds wrote:
This code opens the UserForm Data_Input when I click on a cell within the
range E7:E11. This UserForm has a MultiPage control on it and I want the
code below to open the UserForm and set the Focus to the "Income" page
(page 3) of the MultiPage control.
If Not Application.Intersect(Target, Range("E7:E11")) Is Nothing Then
Data_Input.Show
--
Dave Peterson
|