Is there a way to either click or doubleclick on a cell and have it start a userform? Thanks
R ranswrt Sep 4, 2008 #1 Is there a way to either click or doubleclick on a cell and have it start a userform? Thanks
G Graham Whitehead Sep 4, 2008 #2 Put this code into the sheet that you want it to work on. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then frmMe.Show end sub Which would then load the userform frmMe when cell A1 is clicked
Put this code into the sheet that you want it to work on. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then frmMe.Show end sub Which would then load the userform frmMe when cell A1 is clicked
R ranswrt Sep 4, 2008 #3 Will that work if the cell is locked? I don't want the data to be changed in the cell.
