automating a control box in excel

O

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
 
M

Max

oa501 said:
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
Click to expand...

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
 
Top