Perhaps what you are after is using a Data Validation drop down list, which requires no VBA.

You may either create a list of items on the same or another sheet or, if the list is short just type the items directly in Source box in the dialog.

Menu > Data tab > Data validation > pick List from the options
In the Source box either type the list items: e.g. Orange, Mango, Banana, etc
Or, if you have a longer list, enter the values on a sheet and in the Source box provide the sheet/range reference: e.g. Sheet2!A1:A10

For more detailed help, read here
Plenty of video demos on YouTube as well. Try a search there on Excel Data validation