How do I get a combo box to list my selections?

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I am having a hard time with the combo box. I can't get
the values that I want into my combo box. I have some pre-
detirmined values in cells AA1 - AA5. Please help!!
 
Hi!

I'll assume you are using a Control Toolbox combobox.

Put your combo entries in an array: for simplicity, start with single
column. Open the combo Properties and put the range address of th
entries into ListFillRange.
Wider arrays can be used in comboboxes with corresponding numbers o
columns.

You might also want to use the LinkedCell to extract the ordinal of th
selected item in the combo.

Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a combo box 1
how do I load combo box from Excel columns? 1
Combo box value does not update in Excel 2007 4
Combo box output excel 2007 2
combo boxes 1
Combo Box 1
Excel 2007 Combo Box questions 1
Combo Box / Hard Coded List 1

Back
Top