Topic: Example code ( userform, module )

[MP]

Try this Mark --

Code: [Select]

Public Sub RunMe()
   
    Dim myFormInstance As MyForm
    Set myFormInstance = New MyForm
   
    With myFormInstance
        .Label1.Caption = "A caption."
        .TextBoxMsg.Text = "Some text."
    End With
   
    myFormInstance.Show
    Unload myFormInstance
   
End Sub

[Arizona]

Since you are already displaying the form I believe you need to do a "refresh"

Or put the show form statement under the textbox statements

Never mind...I like Michael's answer better!

[Mark]

question, is MyForm part of the dvb that contains RunMe?  if so, you shouldn't have to load it.
2nd thing - I dont know why it doesn't work.  I will go test it

1) yes
2) OK, thanks.

screen shot coming ....