How do I do this right?
I am on a UserForm codepage in VBE.
I want my code run on the event of a certain page of the MultiPage1 is selected, the one that has the Tag property set to "Pic"
Current solution:
Works, but I would like to improve it so when I move the page backward or forward I do not need to remember to adjust the value property in the above code.![]()
Private Sub MultiPage1_Change() If MultiPage1.Value = 7 Then Run MySub End If End Sub
So the desire would be this:
(Of course .justselectedpage or .justactivatedpage does not exist.)![]()
Private Sub MultiPage1_Change() If MultiPage1.justselectedpage.Tag = "Pic" Then Run MySub End If End Sub
Is it possible?
Bookmarks