I need help understanding how to have userforms on several worksheets. It's the coding I'm focused on.
On one sheet I've created a button assigned to a macro that pops up a multipage window with text. Now that I've started creating another userform (StartHelp) for a different worksheet, I'm running into conflicts.
The little coding experience I have tells me that I need to differentiate each form (and others that have yet to be created). The code for the sheet that works is:
The module for the sheet that works is:
How should I proceed, please?
On one sheet I've created a button assigned to a macro that pops up a multipage window with text. Now that I've started creating another userform (StartHelp) for a different worksheet, I'm running into conflicts.
The little coding experience I have tells me that I need to differentiate each form (and others that have yet to be created). The code for the sheet that works is:
Private Sub CommandButton1_Click()
Unload Me
End Sub
Private Sub Label4_Click()
End Sub
Private Sub UserForm_Initialize()
Me.MultiPage1.Value = iPage
End Sub
Unload Me
End Sub
Private Sub Label4_Click()
End Sub
Private Sub UserForm_Initialize()
Me.MultiPage1.Value = iPage
End Sub
The module for the sheet that works is:
Option Explicit
Public iPage As Integer
Sub help0()
iPage = 0
CharterHelp.Show
End Sub
Public iPage As Integer
Sub help0()
iPage = 0
CharterHelp.Show
End Sub
How should I proceed, please?