Select items from list and show in text box

[rosscojet]

I want to be able to select an items from a list I have setup and have
them show in a text box (possibly with the aid of a select button).
Could someone please explain to me how to do this as I have no idea
about Visual Basic and macros don't work?

Thanks in advance

Jeanette

 

[Debra Dalgleish]

You can create a dropdown list with data validation:

http://www.contextures.com/xlDataVal01.html

Or, create a combobox on a UserForm:

http://www.contextures.com/xlUserForm02.html