Drop Down List

[ServiceChris]

I'm not sure if this is a VB question or not, but so far the help from
this group has been great, so I thought I'd try it anyway.

I have some fields defined as drop down lists for a user to select a
value from. However, what I would like is when the cursor is moved to
the field, I would like the first value of the list to show, and to be
able to use the up & down cursors to select, as well as the drop down
selector. If the user doesn't select an item, I don't want the field
filled. But if the user does press enter, or selects from the list, I
want this to appear in the field. I'm not sure if what I want is
possible, but I thought I'd ask anyway.

Thanks in advance.

Chris

 

[Tom Ogilvy]

Assuming you are using Data Validation dropdowns:
Using up and down arrows is already supported. To make the dropdown drop
down, use Alt+down arrow, then use the arrows to navigate within the
dropdown.
If the user uses the up and down arrows, a selection has essentially been
been made. If they hit escape, then the dropdown will close with no change
to the cell value (no selection - or selection cancelled). The dropdown
begins with whatever value is currently in the cell.

Beyond that, you don't have any control of the operation.

 

[ServiceChris]

Thanks for that. I didn't realise that you could use Alt-arrow to d
that. It works great.

Cheers, Chri