We help IT Professionals succeed at work.

Use Combo to populate cell values

Karen Schaefer
on
34 Views
Last Modified: 2016-03-01
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?

thanks,

K
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Hi, could you upload an example of outcome you are looking for?
Karen SchaeferBI ANALYST

Author

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

Thanks
sample.xlsm
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
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.
Karen SchaeferBI ANALYST

Author

Commented:
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???).

Thanks.
CERTIFIED EXPERT

Commented:
Mechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Karen SchaeferBI ANALYST

Author

Commented:
Excellent thanks
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.