Highlight the current worksheet selection with a color of your choice ?

[Jaafar Tribak]

I am trying to give the current highlighted selection a certain interior color depending on certain conditions as the user drags the mouse or presses Shift+Arrow keys.

I know, by default, excel highlights the current selection by delimiting the selected area but I am looking to give the selection a bright color as well.

Any one got any ideas ?

 

[njimack]

The below will work using Shift+cursor, but dragging doesn't take effect until the mouse button has been pressed.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Application
    .ScreenUpdating = False
    .EnableEvents = False
End With

Cells.Interior.ColorIndex = 0
Target.Interior.ColorIndex = 6

With Application
    .ScreenUpdating = True
    .EnableEvents = True
End With

End Sub

 

[Jaafar Tribak]

Thanks for the quick response Neil.

the code doesn't take effect until the mouse left button has been released which is the limitation I am trying to overcome. I want the color to change dynamically ie : while the selection is being drawn.

 

[Jaafar Tribak]

I guess this cannot be done .It seems that during a selection operation,the application enters a mode and becomes irresponsive which prevents from setting any Properties of any excel class (in this case the Interior.Color Property ).

Retrieving Properties does work however so ,in theory, one could retrieve the selection screen rectangle via the selection address property and paint the rectangle area with some GDI apis but that would be too much work I guess.