Trying to access ListBox object programmatically

I have a userform in the current project named MIGForm, with a ListBox names ListBox1.
In the procedure below, the first Debug.Print line works as it should -- it returns "ListBox" -- so I know that MIGForm.ListBox1 exists and is a listbox. Yet the "Set" line below fails. Would anyone be able to explain why?

The reason this is relevant is that I have written a sub that takes a listbox as an argument and populates it with the elements of a range argument. It would be so convenient to be able to use this, but VBA will not let me use my userform list boxes as arguments to this function.

Please Login or Register  to view this content.

Hello JGPatrick,

The code should work if the your userform is loaded. If the user is not loaded then macro will not work.

Please Login or Register  to view this content.

Change the dim statement to:

Please Login or Register  to view this content.

assuming the error you were getting was 13 type mismatch.