automating a control box in excel

[oa501]

I have used a list box in excel, how do I automate this so that once the
selection is made that's what appears on the sheet

 

[Max]

I have used a list box in excel, how do I automate this so that once the
selection is made that's what appears on the sheet

Use/draw the Listbox from the control toolbox toolbar
Then you could right-click on it & set the Properties, eg
LinkedCell: A1
ListFillRange: B11:B20

When you exit design mode, you'd find that the listbox is populated with the
values in B11:B20 and the selection will appear directly in the link cell A1

 

[ryguy7272]

Take a look at these tutorials:
http://www.meadinkent.co.uk/xldropdown.htm

http://www.lacher.com/examples/lacher01.htm

http://www.contextures.com/xlDataVal02.html
(and scroll down ot the bottom of the page to find more, similar examples)

Regards,
Ryan---