Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an array based on the subroutines in a module
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an array based on the subroutines in a module
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? Are you looking to duplicate what the Macros... dialog does? (CtrlF8) -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an array based on the subroutines in a module
Garry, is it Alt F8 ?
isabelle Le 2017-02-15 à 21:38, GS a écrit : Are you looking to duplicate what the Macros... dialog does? (CtrlF8) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an array based on the subroutines in a module
Garry, is it Alt F8 ?
isabelle Le 2017-02-15 à 21:38, GS a écrit : Are you looking to duplicate what the Macros... dialog does? (CtrlF8) Yes, it s/b Alt+F8; -thanks for catching that! I have something similar that I've assigned to Ctrl+F8 key combo and so typed it by mistake. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an array based on the subroutines in a module
"Matthew Dyer" wrote in message 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? ===================================== Try the "Extended Project Explorer" http://www.jkp-ads.com/Articles/treeview02.asp That should more than give ideas for your first question, but I don't follow your second. Peter T |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create an array based on the subroutines in a module
Try the "Extended Project Explorer"
http://www.jkp-ads.com/Articles/treeview02.asp Oh yeah.., I completely forgot about that project! (Not yet installed on this new machine) -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |