September 02, 202200:07:17

Lesson 48 Excel Vba User Form Show Modal , Dim variable , Global variable

''Module Code
Global a As String
'user Form 1 code
Private Sub CommandButton1_Click()
a = "good"
MsgBox a
End Sub

Private Sub CommandButton2_Click()
MsgBox a
End Sub

Private Sub CommandButton3_Click()
UserForm2.Show
End Sub

'user Form 2 code

Private Sub CommandButton1_Click()

a = "look"
MsgBox a
End Sub

Private Sub CommandButton2_Click()
MsgBox a
End Sub