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

M

MNGopher

I've created a worksheet that utilizes the data>validation>list 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?
 

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

Top