Display full text of selected dynamic combobox in textbox

[keaden]

Hello again folks,
I have a quick question.

I currently have a multipage userform that populates dynamic comboboxes within a frame on a button click.

I was thinking about having a textbox on the same page that will display the full text of the active combobox in the textbox when it is clicked on.

Is this sort of thing possible and if so could anyone point me in the right direction on how to impliment this?

I had thought about creating a class and using WithEvent with a collection of comboboxes but is that possible or am I over complicating things?

 

[keaden]

Mike,
Thanks for the patience, Classes are new to me and I hope I haven't bitten off more than I can chew here.

The frames I mentioned are not created dynamically but there is however a multipage with 10 tabs I'm assuming that the collection will add every dynamically created combobox within the userform?

Does the code you posted allow for the display of the text within the selected combobox in an already created textbox?

 

[mikerickson]

The original code was based on all the comboboxes being created inside a Multipage (any page), not inside a frame, and all of the created comboboxes being linked to the same pre-existing textbox.

The .Tag approach and the "put in collection at creation" is a better (more flexible) solution in my opinion.