Combo Box Take From One Row Source Or Add To Another

MichaelW3

New Member
Joined
Jul 23, 2010
Messages
2
I've developed a user form that's been operational for a while now but needs a change. One of the fields is a text box where users manually type the facility where a particular piece of inventory comes from. I'd like to change that input field to a combo box where users can select from a list of facilities. I have a workbook with two spreadsheets, "sheet1" where all of the userform data is entered into, and "sheet2" as row source information for other combo boxes. What I'd like to do is take all the facilities that have already been entered and add them as a rowsource for the combobox. Then what I'm looking for is a way for the user to type the facilities name into the combo box and if the facility already exists in the facility column of sheet 2 simply select that facility and enter it as data in the appropriate sheet1 column, if it doesn't exist I want the user to be able to enter that facility and have it store in the list on sheet2 as well as the column in sheet1. Kind of confusing, I'd appreciate any help.

Thanks
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,102,288
Messages
5,485,909
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top