Query on Cell

  • Thread starter Thread starter VIVEKMANE
  • Start date Start date
V

VIVEKMANE

Is there any formula for : If we click on cell that cell should change its
color automatically.......

Please reply.......................
 
Try this simple worksheet event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
ActiveCell.Interior.ColorIndex = 6
End Sub

REMEMBER: This goes in the worksheet code area, not a standatd module.
 
Back
Top