Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
here's an interesting thing... I have multiple closely related but specifically individual subroutines clustered in one module (Verbiage). I know that there is a way that VBA can pull out the subroutine names simply cuz when im in the VB editor, the (Declarations) dropdown box lists all of the subs in that module. How could I write VBA that builds an array that lists all of the subroutines in it?
Second Question:like you can use Inputbox() as a simple userform type thing to take in a variable, is there a Combobox() type thing that would list the items in the subroutine array? or do I need to go with a UserForm? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
[Q] How to create new worksheets based on an array (via named range) | Excel Programming | |||
Convert array formula into VBA module | Excel Programming | |||
Can you create a new array based on the value in a column? | Excel Worksheet Functions | |||
Array contents in module page? | Excel Programming | |||
Can subroutines be called based on a commandbutton number? | Excel Programming |