Load an Userform

[Manuel Cavero]

Good morning everyone:

I have to develop a piece of code that calls an useform form two different places. The first one piece of code needs to load an UserForm in memory, so what I doing now if load the UserForm calling forma normal module this way:

UFPAR.PPRUE

Where UFPAR is the UserForm and PPRUE is a Public Sub that loads values in a Dictionary.

From another module I'm calling the Userform with this piece of code:

Private Sub CBPares_click()
UFPAR.PPRUE
UFPAR.Show vbModeless
End Sub

I've a problem with the first item, sometines works right and sometimes VBA gives me an error, telling that the object (UFPAR or the UserForm) is Null, because the first piece of code doesn't load the UserForm.

Trying to change the way of doing the load of the userform, I tryed to used

LOAD UFPAR

or

LOAD (UFPAR)

But VBE doesn't loads the UserForm. Why?

 

[Jerry Sullivan]

Manuel,

I mocked up a workbook with the portions of your code that you provided, and the userform opened and populated the listbox without raising the error. I repeated the call several times from the button sub, and from a procedure in a worksheet module (which is what you appeared to be doing when the error arose as shown in your image).

I suspect the problem is related to your calling the Userform's PPRUE sub, without having first created an instance of the Userform from a Standard Code Module.

I'd suggest you create an instance of the Userform from a Standard Code Module, then populate the listbox instead of trying to do those within the same call.