select multiple buttons

  • Thread starter Thread starter Johan Johansson
  • Start date Start date
J

Johan Johansson

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

Thanks

Johan
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automating a process that uses an add-in 6
Chrome keyboard shortcuts 2
Command Button Ctrl+Alt+Shift_F9 8
how do you deal with excel versions? 8
form buttons on sheet collapse on unhide - sometimes 5
Wait for action 1
Macro Related to Paste Values 2
Excel 2007 Custom ShortCut Keys 1

Back
Top