passing variable from userform

**maacmaac** · 01-31-2010, 12:22 AM

I am using the following code to open a userform. Once the userform is open, the user has the option to choose a continue button or a cancel button. If the user is choosing continue, the code is not working (it always skips to the "else" portion of my "if" statement. I can't figure out why it is doing this. Thanks. I have attached a sample of workbook, if needed.

Please Login or Register  to view this content.

Userform code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**pike** · 01-31-2010, 01:49 AM

Hi maacmaac
all you needed to do was call the sub

try....

Please Login or Register  to view this content.

**mikerickson** · 01-31-2010, 04:07 AM

You could change the userform's code to this. (Note the added function.)

Please Login or Register  to view this content.

and change the calling routine to

Please Login or Register  to view this content.

The technique is like returning the value of a function in a custom Class.
Note: In the Function ContinueUpdate, all references after the Me.Show line should be to DisclaimerForm rather than Me, in case the user Cancels or corner X's.

**Andy Pope** · 01-31-2010, 04:08 AM

Pike's solution will solve your problem.

The reason it does not work is due to the scope of your variables.
The variable Continue declared in the UpdateMasterFile routine is not the same variable used in the button click events.

http://www.ozgrid.com/VBA/variable-scope-lifetime.htm

**maacmaac** · 01-31-2010, 08:22 PM

Code is working fine now. Don't quite understand how the "me" commands work (me.show, me.hide, unload me, etc.). Something I need to study. If you have any recommended links and/or books that explains in depth, I would appreciate it. Thanks for all the comments.