how to check if user has made a selection on the sheet

hi all,
I think its pretty simple but i'm just missing it. Can someone tell me how to check if the user has made a selection or selections on the excel sheet. I want that user selects one or more cells and then clicks a button in the menu bar to change the color of selected cell(s).
thanx in advance for help.
amit

Originally Posted by chawla12amit

hi all,
I think its pretty simple but i'm just missing it. Can someone tell me how to check if the user has made a selection or selections on the excel sheet. I want that user selects one or more cells and then clicks a button in the menu bar to change the color of selected cell(s).
thanx in advance for help.
amit

Hello Chawla,

You can tell by using the following Worksheet Event :
Worksheet_SelectionChange(ByVal Target As Excel.Range)

Target will be the cell or group of cells the user has chosen. You can at this point change the color (no button needed). You can select which cells will be changed by testing with an If statement:

If Target.Address = "$A$1" Then Target.Interior.ColorIndex = 2 'Red

Each Worksheet in the Workbook has this Event.

Hope this Helps,
Leith Ross