LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Q] How to create new worksheets based on an array (via named range) John[_141_] Excel Programming 4 January 10th 12 10:50 PM
Convert array formula into VBA module Forgone Excel Programming 7 November 3rd 08 04:11 AM
Can you create a new array based on the value in a column? Jeff Excel Worksheet Functions 3 May 6th 08 07:06 PM
Array contents in module page? lance Excel Programming 1 October 14th 05 10:53 PM
Can subroutines be called based on a commandbutton number? Jeff Q Excel Programming 1 February 17th 04 02:10 PM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"