UserForm Listbox Not Displaying

[vthokienj]

On a userform, I have a listbox. What I do not understand is why values do not write to the listbox if called from an external module.

A command button on the userform calls a sub that adds text. This text displays. Another sub is called by a module that also writes text, but this text never appears in the listbox.

Both code sections are being called and the listbox is not being cleared anywhere.

What explains this behavior? Thanks

' listbox is populated after calling

Private Sub btnPopulateListbox_Click()
    listboxTest.AddItem "written after button press on form"
End Sub

' listbox is blank after calling

Public Sub PopulateListboxFromModule()
    listboxTest.AddItem "written after called by module"
End Sub

 

[ScottR]

The Sub from your standard module should generate an object required error as you have not specified the userform on which the listbox is created.

Do you have error handling code as well by any chance, or something daft like "on error resume next"?

Anyway, the solution is fairly straightforward

Public Sub PopulateListboxFromModule()
 [COLOR=Red]userformname[/COLOR].listboxTest.AddItem "written after called by module" 
End Sub

 

[vthokienj]

Thank you for the quick reply.

The problem persists even with specifying the form name.

Public Sub PopulateListboxFromModule()
    formMyForm.listboxTest.AddItem "written after called by module"
End Sub

 

[GTO]

"Another sub is called by a module that also writes text, but this text never appears in the listbox."

What other sub is called by what module? Does the userform exist at that time?

 

[vthokienj]

The second of the two function is what I was referring to.

Anyway this is solved by passing an instance of the instantiated userform to the function and calling the listbox property of that.

Thanks for the replies.