Dynamic Userform doesnt update label caption

Hi,
I have multiple Userforms with labels etc, all controls are similarily named (so I could do this) and I can refer to the Userform dynamically but the Label caption/Controls don't change, any idea's how to get them working.

I have zero experience with VBA or any programming for that matter.

this is the Code I use which works but the captions don't change
Thanks in advance for any help.

Please Login or Register  to view this content.

Hi Heresy
change the code to reference the exact name of the userfrom

Please Login or Register  to view this content.

Good morning Heresy

...and welcome to the forum!!

Originally Posted by Heresy

I have multiple Userforms with labels etc, all controls are similarily named (so I could do this) and I can refer to the Userform dynamically but the Label caption/Controls don't change, any idea's how to get them working.

Are you perhaps making this more diccicult than it needs to be?
This works fine for me.

Please Login or Register  to view this content.

You don't need to declare it an an object or anthing else - just announce you want to work with it.

HTH

DominicB

I think you need to xplain what you are doing. Are you trying to create a userform within your code?

Also, you haven't declared Formname as a variable & yo try to use it before giving it value

You need to switch two lines round in your code as Roy said and then show the form:

Please Login or Register  to view this content.

The code I posted does work - did you try it?
If so, is your form set to show modelessly? If it is, you would need to specifically repaint it.