combo box - last value

  • Thread starter Thread starter Matthew Dyer
  • Start date Start date
M

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?
 
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?
Click to expand...

You could make the list a dynamic range that automatically sizes itself
to the number of rows that contain data.
 
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?
Click to expand...
 
Back
Top