Shortcut to make a drop-down LOV show during data entry?
 

I've created a worksheet that utilizes the datavalidationlist function. I
would like to simplify data entry by either using a the form or by causing
the drop-down list to show without having to click it. (I've coded the
entries for 10-key data entry and clicking disrupts the flow, i.e. 0-no,
1-yes. Since the de will be done by a layperson, I want the entry
translated/displayed so that the user may identify potential de errors right
away.)

I found that in form de, the list options don't show and in the spreadsheet,
you must click and then highlight your selection. Excel does not anticipate
your entry if you start typing the first few characters (except when the dd
lov is not used and autocomplete is enabled - I don't want to use
autocomplete due to the need for data validation).

Any suggestions?

Shortcut to make a drop-down LOV show during data entry?
 

Hi,

We are not all privy to your shortcuts LOV (love), dd, de (that one is
easier).

Are you trying to ask how you can get autocomplete in a data validation list?

If so, take a look at these two solutions:

http://www.contextures.com/xlDataVal10.html

http://www.ozgrid.com/Excel/autocomplete-validation.htm


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"MNGopher" wrote:

I've created a worksheet that utilizes the datavalidationlist function. I
would like to simplify data entry by either using a the form or by causing
the drop-down list to show without having to click it. (I've coded the
entries for 10-key data entry and clicking disrupts the flow, i.e. 0-no,
1-yes. Since the de will be done by a layperson, I want the entry
translated/displayed so that the user may identify potential de errors right
away.)

I found that in form de, the list options don't show and in the spreadsheet,
you must click and then highlight your selection. Excel does not anticipate
your entry if you start typing the first few characters (except when the dd
lov is not used and autocomplete is enabled - I don't want to use
autocomplete due to the need for data validation).

Any suggestions?