asked on VBA Dropdown List
Hello Experts,
I would like to add a VBA dropdown list in the cell right below "Name". If the cell to the right (named cell: 'RVStatus') says "Active" then I want the dropdown list to reference named range: EmpActiveAlpha, but if the cell says "In Active" - then I would like the dropdown list to reference named range: EmpInActiveAlpha.
![error1.PNG]()
Thank you in advance for your help!
I would like to add a VBA dropdown list in the cell right below "Name". If the cell to the right (named cell: 'RVStatus') says "Active" then I want the dropdown list to reference named range: EmpActiveAlpha, but if the cell says "In Active" - then I would like the dropdown list to reference named range: EmpInActiveAlpha.
Thank you in advance for your help!
Microsoft ExcelVB ScriptVBA
Last Comment
Martin Liss
ASKER
I received an error when I use the data validation. It basically says it resulted in an error. So instead of troubleshooting that, I just asked about VBA knowing it can be done that way too.
It can be done in VBA, but it's harder to maintain that a DV list.
Can you post a screenshot of the error?
Can you post a screenshot of the error?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
1) From the Data tab on the ribbon, select "Data Validation"
2) Allow "list"
3) Enter this formula in Source...
=IF(RVStatus="Active", EmpActiveAlpha, IF(RVStatus="In Active", EmpInActiveAlpha, ""))
4) Click OK.
Wayne