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

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

AlfD

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
 
Top