If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop Down Starting Position
I have a drop down list in a data validated cell with blank items at the
bottom of the list (to allow for addition user-entered choices). Is there any way, when you click on the drop down arrow, for the menu to start at the top instead of the bottom? Did I do something wrong? Thanks, Jeff |
#2
|
|||
|
|||
Drop Down Starting Position
Get rid of the blank cells and just turn off the error alert if you want to
be able to enter what's not in the list. The user-entered choices do get get added to the list in any case unless you use VBA code. Gord Dibben MS Excel MVP On Mon, 13 Apr 2009 15:13:01 -0700, veggies27 wrote: I have a drop down list in a data validated cell with blank items at the bottom of the list (to allow for addition user-entered choices). Is there any way, when you click on the drop down arrow, for the menu to start at the top instead of the bottom? Did I do something wrong? Thanks, Jeff |
#3
|
|||
|
|||
Drop Down Starting Position
Mis-read.
If you are including blanks for adding to a list, the first blank cell will always be default. Use a dynamic range for the input range. See Debra Dalgleish's site for naming dynamic ranges. http://www.contextures.on.ca/xlNames01.html#Dynamic And this site for adding items to a DV list. http://www.contextures.on.ca/xlDataVal08.html#Dynamic Gord Dibben MS Excel MVP On Mon, 13 Apr 2009 16:49:26 -0700, Gord Dibben gorddibbATshawDOTca wrote: Get rid of the blank cells and just turn off the error alert if you want to be able to enter what's not in the list. The user-entered choices do get get added to the list in any case unless you use VBA code. Gord Dibben MS Excel MVP On Mon, 13 Apr 2009 15:13:01 -0700, veggies27 wrote: I have a drop down list in a data validated cell with blank items at the bottom of the list (to allow for addition user-entered choices). Is there any way, when you click on the drop down arrow, for the menu to start at the top instead of the bottom? Did I do something wrong? Thanks, Jeff |
Thread Tools | |
Display Modes | |
|
|