combo box - last value

[Matthew Dyer]

Also posted in the public.excel group discussion but also bringing it
here cuz i think it will ultimately require macro...

I have a combo box (not activex) that pulls it's values from a column
that varies in length. Currently I'm using the entire row (A:A) for
the input range. As you can guess, this results in MAAANY blank
entries in the box. Is there a formula or some other way so that the
combo box will stop at the end of my range of data without writing a
macro to load it that way?

 

[GS]

It happens that Matthew Dyer formulated :

Also posted in the public.excel group discussion but also bringing it
here cuz i think it will ultimately require macro...

I have a combo box (not activex) that pulls it's values from a column
that varies in length. Currently I'm using the entire row (A:A) for
the input range. As you can guess, this results in MAAANY blank
entries in the box. Is there a formula or some other way so that the
combo box will stop at the end of my range of data without writing a
macro to load it that way?

You could make the list a dynamic range that automatically sizes itself
to the number of rows that contain data.

 

[Dave Peterson]

Check that other post, too.

Also posted in the public.excel group discussion but also bringing it
here cuz i think it will ultimately require macro...

I have a combo box (not activex) that pulls it's values from a column
that varies in length. Currently I'm using the entire row (A:A) for
the input range. As you can guess, this results in MAAANY blank
entries in the box. Is there a formula or some other way so that the
combo box will stop at the end of my range of data without writing a
macro to load it that way?