Thread
:
Excel 2000 Macro
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson[_3_]
external usenet poster
Posts: 2,824
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 With Quote
Dave Peterson[_3_]
View Public Profile
Find all posts by Dave Peterson[_3_]