Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Public Var1
Public Var2 Sub Master() var1 = Inputbox("enter value for var1") var2 = InputBox("Enter value for var2") ABC EFG End Sub Sub ABC() msgbox "Value of var1 is " & var1 End Sub Sub EFG() msgbox "Value of var2 is " & var2 End Sub Another way is to pass the value of the variable to the sub in the argument list. -- Regards, Tom Ogilvy "Aaron" wrote: I have a sub that runs 17 other subs. It takes about a half hour to complete. Throughout the 30 minutes various input boxes pop up. I want to define all the variables through input boxes as the very first step so I can walk away and I don't have to wait for each box to pop up as the program runs. But that means having my variable is one sub and my variable definition in another sub. This does not seem to work. How can I get a defined variable to look into another sub for its meaning? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need variable that refers to same row different column | Excel Discussion (Misc queries) | |||
Variable sum from defined input | Excel Worksheet Functions | |||
Formulas containing variable input | Excel Discussion (Misc queries) | |||
variable/Input box problem | Excel Programming | |||
Input box with variable | Excel Programming |