Why does this not work?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Target.Address = 1 Then
UserForm1.Show
Else
If Target.Address = 2 Then
UserForm2.Show
Else
End If
End Sub
Why does this not work?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Target.Address = 1 Then
UserForm1.Show
Else
If Target.Address = 2 Then
UserForm2.Show
Else
End If
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks