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?
thanks,
K
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
Hi, could you upload an example of outcome you are looking for?
ASKER
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
Thanks
sample.xlsm
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.
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.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Excellent thanks