Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut to change view so that column widths are all wide enough to show all data? | Excel Discussion (Misc queries) | |||
Can I make a data entry box? | Excel Discussion (Misc queries) | |||
Shortcut Key for Data-Filter-Show All? | Excel Discussion (Misc queries) | |||
pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) | |||
Data Entry With Drop down Keypad | Excel Discussion (Misc queries) |