Populate data from a Combobox in a UserForm into a combobox in another UserForm

**johnw993** · 03-02-2015, 02:08 AM

I am not a programmer and still consider myself a novice at VBA, so I'll try to explain this as well as I can. If my question is not clear, or you need to see my code, please let me know.

I am using two UserForms. The first is Userform 1, which is used for entering new data, which contains approx. 90 data entry fields and contains a lot of ComboBoxes and ListBoxes (which allows the user to select the appropriate data).
The second is UserForm2, which is identical in layout to Userform 2, but is designed for a user to find and edit records (that were entered using UserForm1).
When you select a name in the primary field in Userform2, the form populates with the data that was entered by using UserForm1 (and placed in a datasheet). This is working well, but all the data that populates UserForm2 is placed in TextBoxes.
I would like find out how I can populate ComboBoxes in UserForm2 with that data, and then allow the user to change the data by using ComboBoxes in UserForm2.

Any thoughts/suggestions are very welcome,

Thank you,

John

**Kyle123** · 03-02-2015, 04:17 AM

Exactly the same way as you are doing it now, you just need to swap the textboxes for comboboxes and set their .List property. You can then set their values as you would with a textbox

FWIW I'd just have one form

**johnw993** · 03-02-2015, 04:32 AM

Thanks Kyle,
I didn't know it could be that simple. I'll experiment with it.
When I make it work, then yes, I can now build it all into one single UserForm.

Thank you!

I can't express how much I appreciate this Forum and the people (like you) who are providing feedback when I'm feeling stuck.

John

Populate data from a Combobox in a UserForm into a combobox in another UserForm

LinkBack

Thread Tools

Rate This Thread

Display

Populate data from a Combobox in a UserForm into a combobox in another UserForm

Re: Populate data from a Combobox in a UserForm into a combobox in another UserForm

Re: Populate data from a Combobox in a UserForm into a combobox in another UserForm

Thread Information

Users Browsing this Thread

Similar Threads

Userform Combobox to populate form: Can I change the order of the columns in the combobox?

Trying to populate a userform combobox from a userform textbox

Userform Combobox to populate based on selection in another combobox

[SOLVED] Userform combobox to populate RowSource for new values in combobox

[SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select

Bookmarks

Bookmarks

Posting Permissions