Thread: automating a control box in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default automating a control box in excel
"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
---
Reply With QuoteReply With Quote