AutoCorrecting in VBE ??

[Bill]

Hi;

Is there an AutoCompletion-like or AutoCorrect-like utility for VBE
that can be downloaded ??

I was wondering if there was an easy way to complete words in the
codeing window? Some variable names, text, and object names and
properties get tedious to type over and over. Either method
(AutoCompletion or AutoCorrect ) would go a long way towards reducing
typos.

If no one that you know of has created such an add-in, how can I create
macros that I can attach to accelerator keys in VBE only. The macros
would only be used to insert set text into the codeing of the code
window. I would want to easily change the text as my needs change.

All suggestions gratefully received.

Regards Bill

 

[Dave Peterson]

Declare your variables and you'll be able to use ctrl-spacebar to complete the
variable name. If what you've typed isn't unique, you'll see a list of choices.

And if you declare your variables nicely:

Dim wks as worksheet
not
Dim wks as Variant
and not
dim wks as Object

You'll get the VBE's intellisense to pop up once you type the dot following the
variable name.

wks.
will show you a list of properties and methods to choose from.

ps.

I like to include upper and lowercase letters in my declarations:

dim NewWks as worksheet

Then if I type the variable name and it doesn't change case to match my dim
statement, I know that I mistyped my variable. (After you've finished typing
the line, that is.)