Userform help

[zigaria1]

Ok, long story short, i have a userform named "UserFormSPHIX" and I need to set that equal to some type of object or variable named "oUserForm" so that the following piece of code will execute properly:

oUserForm.Label1.Caption = "generic string of text"

The code i currently have looks like this:

Dim oUserForm as UserForm
set oUserForm = UserFormSPHIX

oUserForm.Label1.Caption = "generic string of text"

however, this does not change the caption of label1. It doesn't give me any error message, it just doesn't do anything! Any help would be GREATLY appreciated!

 

[taigovinda]

Welcome to the board!

I've only very recently made my first userform. I had some difficulties also though... Try doing this instead:

dim oUserForm as Object
set oUserForm = new UserFormSPHIX
 
oUserForm.Show
 
oUserForm.Label1.Caption = "generic string of text"

Hopefully it helps - I don't fully understand the issue so can't offer explanations but hoping someone with more experience on the subject will chime in and enlighten us both.

Tai