Click or Double Click

  • Thread starter Thread starter yh73090
  • Start date Start date
Y

yh73090

I couldn't seem to search for what I needed.

I would like to click or double click on a cell and have the range of
row change color.

Is this possible?

Thanks, Y
 
Hi
possible using worksheet event code. e.g. put the following code in
your worksheet module:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Target.EntireRow.Interior.ColorIndex = 3
End Sub

For more about event procedures see:
http://www.cpearson.com/excel/events.htm
 
Back
Top