View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gw.boswell@gmail.com is offline
external usenet poster
 
Posts: 16
Default 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