is there anyway so that if i double click on a cell it will bring pop-up window with the address ?
C cassy01 Sep 24, 2004 #1 is there anyway so that if i double click on a cell it will bring pop-up window with the address ?
F Frank Kabel Sep 24, 2004 #2 Hi you could use a worksheet event. e.g. put the following code in your worksheet module: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) MsgBox Target.Address End Sub
Hi you could use a worksheet event. e.g. put the following code in your worksheet module: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) MsgBox Target.Address End Sub
