Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America asked on

Use Combo to populate cell values

I am trying to create a worksheet that will allow the user to select an employee name for a list and add that value to corresponding cell.  Then go to next row and select another name.

I tried both Form control and activex control but, they only populate 1 cell.

Can someone point me to the correct directions that allow to update multiple rows of data based on a list box in column A?


Microsoft Excel

Avatar of undefined
Last Comment
Karen Schaefer

8/22/2022 - Mon

Hi, could you upload an example of outcome you are looking for?
Karen Schaefer

I need to make column A on SalaryDetail the recipient of the drop down for the list on Reference tab columnA. Named Range = Resource


I don't see any combobox, listbox or data validation dropdowns in your sample workbook.

Even if you had them, I don't see where the information is coming from to populate the Table in worksheet SalaryDetail.

It would be possible to write a Worksheet_Change event macro that traps a user change in worksheet Reference Tables column A. The macro would then access data somewhere else (such as billing rate per month, start date, end date, etc.), then use it to populate the Table on SalaryDetail. But I would need to see the actual worksheet layout of the data (could use fictitious names & billing rates) to write the code.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Karen Schaefer

Would if be possible to direct me to some sample code to create a combo box, I am  very familiar with the code for Access VBA.  However the code for Excel seems to be different.

I want a column (A) Detail for the user to be able to select from a list of names and store the value in the active cell.  and be able to select an new name, to populate the next active cell(A???).



Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Karen Schaefer

Excellent thanks
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.