Excel 2000 Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
(e-mail address removed)
 
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.
 
Back
Top