Combo Box form control

[Copernicus]

2 questions about combo boxes. I have one that references a column with 9 entries. Depending on the value in a cell some of those entries may be blanked out because they are invalid. A blank cell could of course be erroneously selected and need correction. Is there a better way to handle dynamically changing the valid entries in a combo box?

Once I have a valid list/range of entries, I would like to have a separate "advance" mechanism. Eg clicking on a cell advances the selection in the combo box to the next lower entry in the valid list, or the top of the list if its at the bottom. What is the best way to handle that?

Thanks
C

 

[Copernicus]

btw the valid entries in the list are always contiguous.

 

[Copernicus]

bump

 

[Norie]

How exactly are you populating the combobox/comboboxes?

 

[Copernicus]

The regular form control range reference, not VBA. The range contains 9 alpha codes, some of which are blanked out depending on other values.