ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   select multiple buttons (https://www.excelbanter.com/excel-programming/319942-select-multiple-buttons.html)

Johan Johansson

select multiple buttons
 
How do I select multiple buttons? I have tried with ctrl, alt, shift
but nothing works.

Thanks

Johan

gocush[_28_]

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


Tom Ogilvy

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





All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com