Modify in Userform using a variable in a function

Hey guys,

I have N userforms with variable names with X textboxes within.
I want to create a function to call to do something to the userform with the name i desire / from where it has been called in a module.


something like do_this (name_of_the_form, text_inserted_in_textbox, what_text_box)

The problem is that i can't find a way to do something to a userform with a variable name. I've tried to search for it as object, error, declare it as string again resulted in an error.

how i can reference to a Userform From String ? or something

This is a simple example, on the real project yeah....it's quite a mini-mess and im trying to reduce the number of rows (it's a idea)

The code
UserForms.Add(name_of_the_form).Label4.Caption = final_text

Does not work ,
Not updating the userform

the form is already opened , and i am opened to any ideas.

Originally Posted by rorya

How do you intend to use the function - where will you call it from, for example? Does it actually need to be a function, given that you aren't returning anything?

you're right, i've made now a change from function to sub, still not updating in real time.

Originally Posted by mikerickson

Given the name of a userform, this function will return the open userform that has that name.

Please Login or Register  to view this content.

If you want to call one of the subs in a userform, you could use CallByName.

this works nice but i don't understand how / what is the difference between your function and the simple thing as :

Please Login or Register  to view this content.