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