Get properties of userform

[BartH]

Hi all,

I am currently working on a number of Excel files that use userforms.
To help me understand what's going on, I want to be able to report all properties and their values for any specific user form in an open workbook.

This line works fine (a user form in ThisWorkbook):

    Debug.Print frm_RenameLink.Name, frm_RenameLink.Caption
    'result:  frm_RenameLink              Rename Link in Windows Quick Access

but when I want to grab the properties of a user form in another (open) workbook,

    Debug.Print Workbooks("BartAddin.xlam").VBProject.VBComponents("frm_Settings").Name
    ' result: frm_Settings
   
    Debug.Print Workbooks("BartAddin.xlam").VBProject.VBComponents("frm_Settings").Properties("Caption")

I get the "Object expected to be local" message.

How can I resolve this issue so I can read a property from an external user from?

 

[Domenic]

Your syntax seems correct. In fact, I've tested it, and I can confirm that it does return the name and caption.

I'm assuming that you've enabled your add-in and, therefore, the workbook is open. And I'm assuming that both workbooks are opened in the same instance of Excel. Otherwise, a subscript out of range error would occur in both cases.

 

[BartH]

Hi Dominic,

ThnX for your reply.

I have worked out the code into a mini-application which I uploaded here:
https://www.nedcom.nl/Test.zip

Indeed my code works fine there.

Now I went back to the original workbooks and code and much to my surprise, the code ran without a flaw.
So I have to presume something else was causing the problem (but I'll never know what).

So again: "have you restarted already" seems to have done the trick.

Grtz, Bart