ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Passing variable among controls (https://www.excelbanter.com/excel-programming/381919-passing-variable-among-controls.html)

[email protected]

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


Gary Brown

Passing variable among controls
 
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



[email protected]

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 -




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com