Keep cell selection

[Johnny E. Jensen]

Hello NG

In a excel sheet i have 5 buttons. Colored red, green, blue, yellow and
purple.

The user must select some celles on the sheet and then click on a button.
The click should call a VBA code and place the button backcolor in the
selected cells.

My problem is that when the user clicks the button, the selected cells
disappears.
Is there a way to hold the selection until the user has clicked a button?

Kind regards

Johnny E. Jensen

 

[Rick Rothstein]

If you use CommandButton's from the Control Toolbox toolbar, then you can
set its TakeFocusOnClick property to False... do this will keep the cell
selection selected when the CommandButton's is clicked.

 

[Paul]

'Add this line to the start of your sub
cOldSelection = Selection.Address

' Add this one as the last line of your sub
Range(cOldSelection).Select