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

"oa501" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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---

--
RyGuy


"Max" wrote:

"oa501" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---