Passing variable string from WorkbookOpen to userform

[Nyanko]

I'm trying to pass a string value from the WorkbookOpen module to a label or textbox on a userform. This will enable me to devise a custom welcome splash screen

I can't seem to pass the contents of the variable from the module to the userform. I've researched and either my search terms are wrong or I can't find the solution I'm looking for. Thought it would be simple

 

[Norie]

Did you see Rory's post, #6 I think?

 

[Nyanko]

Where specifically (which module) is this line:

Public pwdmsg As String

Note: if you use the syntax I posted, you don't need a public variable.

I just realized I had a duplicate declaration of the pwdmsg in the Workbook_Open() module it's working great now

 

[crazypabs]

I tend to use a text box which is hidden on the form. when the open event initializes the form it populates the text box, then when any eent is executed on the form i refer to the value held in the text box. that way you wont get memory lifetime and scope issues.

hope it helps

Cheers

M