COMBO

[MERKY]

I have a combo box that has blank lines on the drop-down list. I need to know if there is a way to hide these

[Juan Pablo González]

Is your combobox linked directly to the worksheet ? how about creating a dynamic range that adjustes itself and uses only filled cells ?

[MERKY]

the combo box is linked to another sheet in the same workbook. Can u tel me how create a dynamic range. i dont have a cule how to do it.

[Tom Schreiner]

What is the range your list refers to?
In which sheet.
This is one way you could do this.
Set the combobox's ListFillRange in the worksheet's activate event. This way, everytime you activate this sheet, the combobox list would be refreshed. If the blanks are at the bottom of your list, then this will work as is. If your blanks are intermittently placed then you will need to sort the range or transpose it without the blanks to another list.
Tom

[Yogi Anand]

On 2002-05-11 10:43, MERKY wrote:
the combo box is linked to another sheet in the same workbook. Can u tel me how create a dynamic range. i dont have a cule how to do it.

Let us say your list begins at cell A11 and then the other items are in cell A12, A13, ... it may grow

then INSERT|NAME|DEFINE
then in Names_in_Workbook box put ListDynRng
and in Refers_to box put =OFFSET($A$11,0,0,MATCH("zzz",A11:A65536),1)
then OK

Now click on Combo box then in the CONTROL tab
in the Input_range box put ListDynRng
in Cell_Link box ... put your cell ref
then OK

Now you have a combobox that houses the List with Dynamic range

Please post back if it works for you ... otherwise explain a little further and let us take it from there.

Regards!