Pass public variable to Sub

[Paul_Hossler]

One additional comment / suggestion / personal style:

I like to keep userform (UserForm1) and application (ThisOutlookSession) code limited to only those macro(s) that are truly part of the object, and just call any non-Object macros that I have in a standard module

So if ButtonOK_Click() needed to update a database for example (instead of Msgbox), instead of inserting X number of lines in the event handler, I'd just call a stand alone sub in a standard module

You can mark this thread SOLVED -- #3 in my sig

[vbmalik12345]

One additional comment / suggestion / personal style:

I like to keep userform (UserForm1) and application (ThisOutlookSession) code limited to only those macro(s) that are truly part of the object, and just call any non-Object macros that I have in a standard module

So if ButtonOK_Click() needed to update a database for example (instead of Msgbox), instead of inserting X number of lines in the event handler, I'd just call a stand alone sub in a standard module

You can mark this thread SOLVED -- #3 in my sig

It worked... Thanks