code in userforms

[bharnett]

Probably a dumb question, but I'm starting to have a lot of code for 2 userforms and it seems that excel will not let me have code in other modules that are specific to the values/variable assocatied and stored within the userform. For example, I have my intiliazation code in the userform code, but if cmdbutton block of code, I can't have that call code that is in another module, i have to put it in userform too. It is just getting cluttered and I wanted to know if there is a better or easier way to Organize my data. Thanks.

 

[BrianB]

It is really only necessary to have code in a Userform code module that deals with its events. Rather like a worksheet code module. This can run subroutines in other modules.

This code shows 2 methods of sharing variables between modules.

1. Declare variables top of module as Public - makes them available to all modules in all MS Office applications

2. Userforms retain their values until unloaded, so it is often useful to include code to Hide (or Show) the form eg. included in a button_click routine.

'- in a standard code module
Public MyString As String

Sub test()
    MyString = UserForm1.TextBox1.Value
    MsgBox (MyString)
End Sub

 

[bharnett]

thanks a ton! I'm a little embarassed I didn't think of that! Thanks again