refer to a listbox by a string value?

[Fyr]

Here's what I'm trying to do.
Set a custom document property ThisWorkbook.CustomDocumentProperties("_DOCPROPNAME") the name of a listbox (Listbox1).

ThisWorkbook.CustomDocumentProperties("_DOCPROPNAME") = "LISTBOX1"

Then when trying to refer to the listbox from a worksheet use

Userform1."ThisWorkbook.CustomDocumentProperties("_DOCPROPNAME")"

I know this will not work, but is something like this possible?

 

[GlennUK]

Is this any use? :

http://www.ozgrid.com/VBA/control-loop.htm

 

[RoryA]

You need something like:

Userform1.Controls(ThisWorkbook.CustomDocumentProperties("_DOCPROPNAME"))

or:

CallByName(Userform1, ThisWorkbook.CustomDocumentProperties("_DOCPROPNAME"), VbGet)