Why did XL stopped showing me the Macro Commands List

[Martyn]

I must have done something wrong. While I was in the VBE 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

 

[Robert Rosenberg]

In the VBE, Click Tools-->Options. On the Editor Tab check "Auto List
Members"

 

[Martyn]

Thanks Robert but "Auto List Members" is already checked.

 

[A.W.J. Ales]

Martyn,

I suppose you at the same time checked Auto Quick Info as well ?
That the component that's deciding about "adding the tips to your command
typing".

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Martyn]

Regards A.W.J. Ales,

Thanks for your reply. All Edit options were checked, including:
-------------
Auto Syntax Check
Require Variable Declaration
Auto List Members
Auto Quick Info
Auto Data Tips
---------
I removed the check from "Auto Quick Info" and try to type a command. It
make no changes...
What should be the "ideal" checked position of all options under Tools >
Options in VBE Editor?. I may have made a mess out of the settings...

Martyn

 

[A.W.J. Ales]

Martyn,

I don't know what YOUR ideal checked position would be.
As far as my setup is concerned, everythinh on the Editor Tab is checked and
I've set the Tab width to 3.
From this I think only Require Variable Declaration you should consider to
be *needed* to to be checked, but actually I should check everyone of them.
--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Martyn]

Ales,
Thanks but I may need to contact support.microsoft.com
I haven't solved my problem yet.

 

[A.W.J. Ales]

I know I didn't solve your problem with my last posting.
I was just a reaction on your question on the ideal checked position.

Please report back to this thread after your contact to support from
microsoft.

If not *to* technical I would like to know what your solution is, so maybe I
(or you) can help someone else with the same problem in the future.

Succes,
--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Ales,
Thanks but I may need to contact support.microsoft.com
I haven't solved my problem yet.

 

[Robert Rosenberg]

2 more things to try:

1. Use the Debug-->Compile command to see if your code runs into any
problems. If it does, fix the problem(s) until the command yields no errors.
Then try lising the members.

2. Reboot your machine.

 

[Don Guillett]

Try my solution posted in misc

 

[Martyn]

Thanks Don, posted my reply there...

Try my solution posted in misc

--
Don Guillett
SalesAid Software
(e-mail address removed)
on

 

[Martyn]

Hi Robert,
Thanks for your post.
It is good to be replied by a Microsoft MVP - Excel.
But what exactly am I to do in order to "try lising the members"?

 

[Chip Pearson]

Martyn,

Does CTRL+Spacebar bring up the list of items?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

Do you declare you variables as

Dim rng as Range
Dim nm as Name

If you don't, then you won't get any intellisense because Excel doesn't know
what type of variable they are. You only get intellisense on typed
variables. Of course if you are getting nothing at all, then that wouldn't
be the problem.

 

[Martyn]

Sorry Tom,
Shame on me!. I must have been confused by the variable names.

 

[Martyn]

Yes it does...
Shame on me!. I must have been confused by the variable names.
Sorry to take everyones time.

 

[A.W.J. Ales]

It seems that it works for you Martyn, but now *I* am lost.
I thought we were talking of getting help by typing your VB formula's (i.e.
Msgbox was - during the typing - "completed" by XL with (Prompt, [Buttons as
....) in italics.
I don't see any effect from Cntr + Spacebar. Is this something special to
XL2000 (I'm working on WinXP with Excel XP ) or am I missing rhe point (if
so :which point am I missing) ???

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Martyn]

Since I work on a PC with Win98SE + XL2000 only, I can only approve that
Ctrl+Spacebar in the VBE with at least sheet or workbook VBedit page open
pop's up the commend help window. But thinking in *logical* terms it should
do the same with WinXP+ExcelXP shouldn't it?
Regards
Martyn

 

[A.W.J. Ales]

Forget it for the time being Martyn.
I don't understand yet, but I see in the view menu of VBE that Ctrl+Spacebar
is "Complete Word" (at least in XL XP). I'll take a further look at it
after having seen whether that is the same in XL97. I'll somehow figure it
how at some stage, but don't want to spoil to much time on it now.

Anyhow it somehow doesn't do anything for me (and up to now I've not be
missing it as well).
I don't like the idea to start this thread all over again <g> and I'm
perfectly happy with the way the VBE worked for me up to now.

But nevertheless thanks for you answering.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Since I work on a PC with Win98SE + XL2000 only, I can only approve that
Ctrl+Spacebar in the VBE with at least sheet or workbook VBedit page open
pop's up the commend help window. But thinking in *logical* terms it should
do the same with WinXP+ExcelXP shouldn't it?
Regards
Martyn

It seems that it works for you Martyn, but now *I* am lost.
I thought we were talking of getting help by typing your VB formula's (i.e.
Msgbox was - during the typing - "completed" by XL with (Prompt,

[Buttons

as
...) in italics.
I don't see any effect from Cntr + Spacebar. Is this something

special

 

[Martyn]

OK. Ales,
If you are perfectly happy with your Excel's VBE, then keep up the good
work.
Regards