Hello, I have a multipage form that runs some code on Userform_Activate (populate combo boxes). The first line of the code opens the form to page 1 (actually the zero index of the form), with this code:
On another page, I have some code which suggests to the user the data format which should be entered, which is:
Private Sub txtSN1_Enter()
msgbox "Enter value in numbers only", vbOKOnly
End Sub
What happens is, when the form is opened, instead of doing first the Userform_Activate event, it is running the code for the txtSN1_Enter event. then the Activate code is ignored and the combo boxes not populated. Can anyone advise me how to correct this?
Bookmarks