Hi,
Am having some trouble expanding the range of this macro, I would like it to go from A5:AA5 so when someone double clicks the cell the form will open for this row.
Many Thanks![]()
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target(1, 1).Address = "$A$5" Then Cancel = True UserForm1.Show End If End Sub
Karl
Bookmarks