Assuming you want the users to only choose from the selected list.
Try using Data Validation.
Go to an area on your sheet and enter the list of valid choices
Then on the cell where you want the drop down list. Go into DATA - VALIDATION
In the ALLOW drop down box choose LIST
In the SOURCE area enter the cell ranges that have the list of valid choices.
This does not require any VBA code.
Trust this helps