simple question ...

Mar 13th, 2002, 05:03 PM

Hi guys.

I am sorry for bothering you all, but I have a question I cannot seem to be able to solve.

Is there any way to asign, selected macros to a button?

I have over 40 Macros in a spreadsheet, and therefore 40 Buttons.

Is there any way I can make several drop down buttons (or otherwise) that will have the ability to have selected macros as options within the drop down?

For example, of the 40 Macros, 10 are for Suppliers, and 15 are for Customers.

So I would like a button that can list for me the 10 Supplier macros, without having all the other macros within the list.

Is there a way to do this?

Any help is really appreciated

Anne Troy · Mar 13th, 2002, 05:39 PM

http://www.cpearson.com/excel/menus.htm#vba

And this is cool to have:

http://j-walk.com/ss/excel/tips/tip67.htm

brettvba · Mar 13th, 2002, 05:40 PM

make a custom menu with a drop down list and get it to boot up with the workbook and hide when the workbook closes

Mar 13th, 2002, 06:26 PM

Hi again,

Thanks for the suggestions. I had a look at the site pages, and worked them through. Only problem being, is that these solutions alter the menu set up. I need for the solution to be within the spreadsheet cells. Ie. Through a drop down box, or list box of some sort.

Any ideas?

Corni · Mar 13th, 2002, 09:46 PM

Add a combo box from the Forms toolbar, select input range for a range of cells to contain macro names which could be selected in the box, and set up a cell link (for ex. "A1". Then include in the Dropdown1_Change macro linked to the control a select case statement like this:

Select Case Cell(1,1)
Case 1
Macro1
Case 2
Macro2
...
End Select

where Macro1, Macro2, etc. represent the name of the macros to be run when selection 1, 2 etc. is made.

Mar 13th, 2002, 05:39 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	http://www.cpearson.com/excel/menus.htm#vba And this is cool to have: http://j-walk.com/ss/excel/tips/tip67.htm __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 05:03 PM	#1
Guest Posts: n/a	Hi guys. I am sorry for bothering you all, but I have a question I cannot seem to be able to solve. Is there any way to asign, selected macros to a button? I have over 40 Macros in a spreadsheet, and therefore 40 Buttons. Is there any way I can make several drop down buttons (or otherwise) that will have the ability to have selected macros as options within the drop down? For example, of the 40 Macros, 10 are for Suppliers, and 15 are for Customers. So I would like a button that can list for me the 10 Supplier macros, without having all the other macros within the list. Is there a way to do this? Any help is really appreciated

Mar 13th, 2002, 05:40 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	make a custom menu with a drop down list and get it to boot up with the workbook and hide when the workbook closes

Mar 13th, 2002, 06:26 PM	#4
Guest Posts: n/a	Hi again, Thanks for the suggestions. I had a look at the site pages, and worked them through. Only problem being, is that these solutions alter the menu set up. I need for the solution to be within the spreadsheet cells. Ie. Through a drop down box, or list box of some sort. Any ideas?

Mar 13th, 2002, 09:46 PM	#5
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	Add a combo box from the Forms toolbar, select input range for a range of cells to contain macro names which could be selected in the box, and set up a cell link (for ex. "A1". Then include in the Dropdown1_Change macro linked to the control a select case statement like this: Select Case Cell(1,1) Case 1 Macro1 Case 2 Macro2 ... End Select where Macro1, Macro2, etc. represent the name of the macros to be run when selection 1, 2 etc. is made.