I got some code from royUK late last night to initiate a userform when a cell is selected.
Here is the code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Address
Case "$G$77": ufMutualAid.Show
Case "$L$79": ufPersonnel.Show
Case "$L$81": ufApparatus.Show
Case Else: 'do nothing in other cells
End Select
End Sub
The code works if the target cell is not merged with other cells, but I need the cells to be merged. Do I need to name a range of cells or what would the proper way to fix this be? If needed, I can post the worksheet.
Bookmarks