Click or Double Click

[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

 

[Frank Kabel]

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