Calling a sub with a variable...

G

Guest

For instance... I have it so that my program lets the user select all available macros from a dropdown list... Hard coded for now. It stores their selection in a variable called varpick... So when I do this:

Call varpick

It doesn't like it. Is there any way I can call a subroutine with a variable? Please tell me there is!
 
R

Rob Bovey

Gary Phillips said:
For instance... I have it so that my program lets the user select all
Click to expand...
available macros from a dropdown list... Hard coded for now. It stores their
selection in a variable called varpick... So when I do this:
Call varpick

It doesn't like it. Is there any way I can call a subroutine with a
Click to expand...
variable? Please tell me there is!

Hi Gary,

Try: Application.Run varPick

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling a sub 3
Can you create a global variable ? 11
Assign Sub Name to a Variable 3
Opening a list of Excel files and run a macro in each 17
send sub routine variable to global 2
Question What determines if publlic variable content is destroyed 6
Calling a sub method 5
Assign Selection to a Variable 2

Top