Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Paste Selection - Delete Selection | Excel Programming | |||
How to create a selection list then display the selection in a cell | Excel Programming | |||
Change from Column Selection to Cell Selection | Excel Programming | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |