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.
P.S. Are there any good online VBA courses that anyone knows of?
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.
P.S. Are there any good online VBA courses that anyone knows of?