combo box - last value

M

Matthew Dyer

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?
 
D

Dave Peterson

If you're using code to assign the entire column (not row) to the dropdown (is
it a dropdown from the Forms toolbar), you could modify it to use just the used
cells.

If you're assigning it manually and you don't have any empty cells in the range
to use, you may be able to use a dynamic named range.

Debra Dalgleish shares instructions for that kind of dynamic name:
http://contextures.com/xlNames01.html#Dynamic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box - last value 2
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Combo box 0
Iterating the combo box and displaying the value after each change onseprate sheet. 2
Populate a table based on check box status 2
Forms Control or ActiveX combo box 2
Combo box issue - Is there a limit on rows in Excel 2003? 1

Top