Can a control panel/page/sheet be created in Excel that can be used to launch macros? I'm thinking of something like the Access switchboard. I've searched but can't find anything.
Thanks,
Chas.
Cotton has another Excel question
-
Topic author - Site Admin
- Posts in topic: 2
- Posts: 17787
- Joined: Wed Dec 22, 2004 9:31 pm
- Location: Friendswood, TX
- Contact:
-
- Senior Member
- Posts in topic: 1
- Posts: 5488
- Joined: Wed Aug 25, 2010 9:13 am
- Location: Klein, TX (Houston NW suburb)
Re: Cotton has another Excel question
Sure. Depends upon what version of Excel for the exact menu choices. Go to the designer menu, Controls, and Insert a button control. You can assign any macro you want to the button_click event. You can label with any text you want.Charles L. Cotton wrote:Can a control panel/page/sheet be created in Excel that can be used to launch macros? I'm thinking of something like the Access switchboard. I've searched but can't find anything.
Thanks,
Chas.
If you want to get more complicated, you can also insert radio buttons, combo boxes, check boxes, spin controls, etc.
If you want some specific help, you can shoot me a PM or email.
-Just call me Bob . . . Texas Firearms Coalition, NRA Life member, TSRA Life member, and OFCC Patron member
This froggie ain't boiling! Shall not be infringed! Μολών Λαβέ
This froggie ain't boiling! Shall not be infringed! Μολών Λαβέ
-
- Senior Member
- Posts in topic: 1
- Posts: 579
- Joined: Thu Dec 15, 2011 8:15 pm
Re: Cotton has another Excel question
You can easily assign macros to buttons. You can also run code automatically when the Excel workbook is opened.
-
Topic author - Site Admin
- Posts in topic: 2
- Posts: 17787
- Joined: Wed Dec 22, 2004 9:31 pm
- Location: Friendswood, TX
- Contact:
Re: Cotton has another Excel question
Thanks folks. I'll create a separate sheet to house the buttons.
Chas.
Chas.
-
- Senior Member
- Posts in topic: 1
- Posts: 1719
- Joined: Sat Jul 03, 2010 12:37 pm
- Location: Alvin, TX
Re: Cotton has another Excel question
You may already be aware of the following:
What version of Excel are you running? In 2007 and up, if you click on the big office button in the top left and select Excel Options, you should see a check box for "Show Developer tab in the Ribbon". This will add a tab that has various controls.
What version of Excel are you running? In 2007 and up, if you click on the big office button in the top left and select Excel Options, you should see a check box for "Show Developer tab in the Ribbon". This will add a tab that has various controls.
... this space intentionally left blank ...