Keep cell selection
 

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

Keep cell selection
 

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.

--
Rick (MVP - Excel)


"Johnny E. Jensen" wrote in message
...
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

Keep cell selection
 

'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


--
If the post is helpful, please consider donating something to an animal
charity on my behalf.


"Johnny E. Jensen" wrote:

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

.