Posted to microsoft.public.excel.programming

keri

external usenet poster

Posts: 74

Using a variable in more than one sub procedure

I currently have this is a sub and parts of the sub use the answer.
This sub will run first.

Dim answer as integer
answer = inputbox(How many sheets?)

However i would like to use the answer again in another sub that runs
later, without the input box again. Is this possible?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Procedure name as variable	Redbeard	Excel Programming	15	May 2nd 06 11:17 AM
Variable procedure call	Art	Excel Programming	2	December 16th 05 01:16 PM
Call procedure using variable	donbowyer	Excel Programming	2	October 28th 05 09:21 AM
Public/Procedure Variable	Otto Moehrbach[_6_]	Excel Programming	2	February 6th 04 04:58 PM
can I call a procedure using a variable	Santiago Gomez	Excel Programming	8	December 24th 03 09:08 PM

All times are GMT +1. The time now is 06:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us