Userform in Personal

[Roderick_E]

Excel 2016
Trying to simply use a Userform in Personal.xlsb (binary) Personal workbook but when I run the personal macro to show the form, it throws up popup, "Object Required"

Code I'm using is simple:

Sub showxlst()
UserForm1.Show
End Sub

Yes, the form is called UserForm1 So what am I missing to make this work? Thanks

 

[Norie]

Where is the posted code located?

 

[Roderick_E]

In a module in Personal

 

[Roderick_E]

changed code for testing to:

Sub showxlst()
     Dim objLoop As Object
     
    For Each objLoop In VBA.UserForms
     MsgBox objLoop.Name
    Next objLoop
   
End Sub

But it returns nothing (no msgbox) which would seem that the object/form doesn't exist, though I can see it in the editor.

 

[Norie]

Is there any code in the Initialize or Activate events of the userform?

 

[Roderick_E]

Is there any code in the Initialize or Activate events of the userform?

Yes, THAT was it. hindered the load/show -- thanks for having your brain near enough that it helped me