![]() |
select multiple buttons
How do I select multiple buttons? I have tried with ctrl, alt, shift
but nothing works. Thanks Johan |
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 |
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