Userform Texbox Collection?

Dear MS Excel Expert.

I am trying to do the following. I want to access textboxes dynamically using a strMyTextBox variable. Is there such thing as Control or TextBox collection for UserForms?


>> My attempt >>

Please Login or Register  to view this content.

What is the Syntax to do this?

Thank you.

Though I am not so sure about what your exact requirement is.. but following code might help you..

Please Login or Register  to view this content.

Let me know if this helps..

Hi, Just an alternative:-

Please Login or Register  to view this content.

Regards Mick

Thank you guys.

Peter