Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select multiple buttons
How do I select multiple buttons? I have tried with ctrl, alt, shift
but nothing works. Thanks Johan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select multiple buttons
Assuming you want to do this manually try holding down the Ctlr and Shift
keys then left clicking the mouse (which is pointed at the controls one at a time) to use vba code try: Activesheet.Shapes("Button 1", "Button 2").Select "Johan Johansson" wrote: How do I select multiple buttons? I have tried with ctrl, alt, shift but nothing works. Thanks Johan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select multiple buttons
Manual Method
This would apply to buttons from the forms toolbar for controls from the control toolbox toolbar you must be in design mode and then only shift is required For the VBA method: Activesheet.Shapes.Range(Array("Button 1", "Button 2")).Select -- Regards, Tom Ogilvy "gocush" wrote in message ... Assuming you want to do this manually try holding down the Ctlr and Shift keys then left clicking the mouse (which is pointed at the controls one at a time) to use vba code try: Activesheet.Shapes("Button 1", "Button 2").Select "Johan Johansson" wrote: How do I select multiple buttons? I have tried with ctrl, alt, shift but nothing works. Thanks Johan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select several control buttons at once on an Excel sheet | Excel Discussion (Misc queries) | |||
Independent radio buttons so I can select more than one | Excel Discussion (Misc queries) | |||
How to Select multi from drop down (field buttons) | Charts and Charting in Excel | |||
Buttons - Select All ? | Excel Programming | |||
Option buttons to select a row of cells | Excel Programming |