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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing variable among controls
Gary,
I still don't understand how you would pass the value (flag) from the TextBox to the spreadsheet then get it back to the command button. Remember that the code in the command button runs with each click event. I tried an if....then....else code but it requires that the flag be transferred into the command button on the second command button click event. Garry On Jan 25, 12:10 pm, Gary Brown wrote: How about putting the variable in a hidden/very hidden worksheet and referencing it that way? -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. " wrote: 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- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing variable among controls | Excel Programming | |||
Passing Controls on a form between modules | Excel Programming | |||
Passing variable to VarType of other Variable | Excel Programming | |||
Passing a variable between workbooks | Excel Programming | |||
Passing variable from one sub to another | Excel Programming |