Why did excel stopped showing me Macro Commands Help Window ?

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
 
P

Peo Sjoblom

When you are in the VBA editor do tools>options there you can set things
like that
 
M

Martyn

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?
 
D

Dave Peterson

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

Similar Threads

Why did XL stopped showing me the Macro Commands list? 0
Why did XL stopped showing me the Macro Commands List 19
XL2000 stopped showing me the Macro commands list 4
Screen update or visible? 4
Excel 2007 macro assigned to button 3
When something in module is shown as a macro 3
Chip Pearson UDF returns #VALUE! error please help, just cannotfigure out why? 4
Excel opening MSSynch in 2010? How to stop it? 0

Top