Multipage Userform Events

  • Thread starter Thread starter SA3214
  • Start date Start date
S

SA3214

Once again I crave the assistance of this group

Is there an event which I can use that will be triggered when, say page 3,
of a multipage form is displayed ?

Regards to all
and
TIA
 
Try something like

Private Sub MultiPage1_Change()
If MultiPage1.SelectedItem.Index = 2 Then
MsgBox "third page selected"
End If
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I've never used a multipage form, but fooling with it I see that the Change
event fires when you switch pages. Interestingly, it doesn't fire when I
click a checkbox or enter text in a textbox. So maybe something like this:

Private Sub MultiPage1_Change()
MsgBox Me.MultiPage1.SelectedItem.Name
End Sub

Finally, as Kramer might say, "You crave, but do you yearn?"

hth,

Doug
 
Thanks Doug but as you point out it runs even when changing between pages 1
& 2
To get it to work as I wanted I would have to test the SelectedItem.Name
using an If statement before running the code

The response from Chip is more elegant solution but many thanks for your
suggestion
 
Me too .... but I console myself with the words of Gen. Lee Butler

"However haltingly, we have made some progress."

<g>
 
Me too .... but I console myself with the words of Gen. Lee Butler

"However haltingly, we have made some progress."

<g>
 
Back
Top