Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Macro
How can I code a Macro to recognize keyboard inputs
without first using the Enter Key? For Example if I enter "Col" I want a pop-up box to show previous Entries which might be "Columbus", "Colorada", "Collingwood" The Pop-up would be progressive with the letters entered. And if there is a "Match" I want to select it. (IE does this when I enter a URL.) Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Macro
Useful macros won't run while you're still in the edit mode.
But there is an option you might want to try: Tools|Options|Edit tab Check "Enable Autocomplete for cell values" It' uses the cells above to help complete the current cell. Or you could use a combobox from the control toolbox toolbar. There's a .matchentry property that you can set to do what you want. wrote: How can I code a Macro to recognize keyboard inputs without first using the Enter Key? For Example if I enter "Col" I want a pop-up box to show previous Entries which might be "Columbus", "Colorada", "Collingwood" The Pop-up would be progressive with the letters entered. And if there is a "Match" I want to select it. (IE does this when I enter a URL.) Thanks for any help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Formula or Macro | Excel Discussion (Misc queries) | |||
How do I record a macro in Excel 2000? | Excel Discussion (Misc queries) | |||
How do you run a Macro from an IF statement in Excel 2000? | Excel Worksheet Functions | |||
Macro in Excel 2000 | Excel Discussion (Misc queries) | |||
Macro in Excel 2000 | Excel Discussion (Misc queries) |