Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing variable among controls
I have searched previous posts and found how to pass a value from a
module to a form or a value from a form to a module. My problem is a little different. I want to pass a value within a userform from a textbox to a command button. I have a userform which has 3 rows of TextBoxes. When the form is called, only one row is visible (the other two are hidden). The user enters data into the TextBoxes. Now when the commandbutton is clicked the second set of TextBoxes becomes visible. OK so far. When data is entered into the second set of TextBoxes a flag is set. Now when the commandbutton is clicked, using an if...then construct I want to call up the third set of TextBoxes. The problem is that the flag value does not transfer to the commandbutton. I have declared the flag as a public variable in the declarations area of the calling module but that doesn't seem to help. Any suggestons |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Controls on a form between modules | Excel Programming | |||
Passing variable to VarType of other Variable | Excel Programming | |||
passing variable to file... | Excel Programming | |||
Passing a variable between workbooks | Excel Programming | |||
Passing variable from one sub to another | Excel Programming |