Why did excel stopped showing me Macro Commands Help Window ?

  • Thread starter Thread starter Martyn
  • Start date Start date
M

Martyn

I must have done something wrong. While I was in the VBA Editor working on a
macro, Excel2000 used to show me suitable commands as I type in...Now
suddenly it stopped. I'd appreciate if someone help me correct this.
TIA
Martyn
 
When you are in the VBA editor do tools>options there you can set things
like that
 
The settings seems to be set OK there.
All check boxes are checked...
Do you know any spesific setting that needs to be in acertain selection mode
there?
 
What kind of variable has lost the intellisense (or is it all of them)??

If you do:

Dim Wks as worksheet
Then type
wks.

Do you see the intellisense pop up?

(I was guessing that you my have an undeclared variable (so it's a variant) or
just a variable declared as a variant--so that excel wouldn't know what to even
try.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top