What I am attempting to do is show a userform if A1 = 5.
In another section of code, I made a few userforms come up if a certain cell was selected. I thought I could utilize the same code and just add to it allowing me to show a uf if the content of a certain cell = a predetermined number(s) or letter(s)
This is the code that I tried to use but did not work.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Address
Case "$A$80:$BI$80": ufMutualAid.Show
Case "$A$83:$BI$84": ufPersonnel.Show
Case "$A$87:$BI$87": ufApparatus.Show
Case "$A$90:$BI$90": ufExtricationTools.Show
Case "A1=5": ufMutual Aid.Show
Case Else: 'do nothing in other cells
End Select
End Sub
Do I need a different sub or can I just change something in this one to make it work? I also tried
Case "A1"=5: ufMutualAid.show
and it also did not work.
Thanks in advance for any help.
Bookmarks