Why did XL stopped showing me the Macro Commands List
 

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

Why did XL stopped showing me the Macro Commands List
 

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

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

"Martyn" wrote in message
...
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

Why did XL stopped showing me the Macro Commands List
 

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

Why did XL stopped showing me the Macro Commands List
 

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" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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" wrote in message
...
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" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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

"A.W.J. Ales" wrote in message
...
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

Why did XL stopped showing me the Macro Commands List
 

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 *

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

"A.W.J. Ales" wrote in message
...
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

Why did XL stopped showing me the Macro Commands List
 

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.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"Martyn" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

Try my solution posted in misc

--
Don Guillett
SalesAid Software

"Martyn" wrote in message
...
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

Why did XL stopped showing me the Macro Commands List
 

Thanks Don, posted my reply there...

"Don Guillett" wrote in message
...
Try my solution posted in misc

--
Don Guillett
SalesAid Software

"Martyn" wrote in message
...
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

Why did XL stopped showing me the Macro Commands List
 

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


"Robert Rosenberg" wrote in message
...
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.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"Martyn" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

Martyn,

Does CTRL+Spacebar bring up the list of items?


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


"Martyn" wrote in message
...
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"?


"Robert Rosenberg" wrote in message
...
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.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"Martyn" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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.

--
Regards,
Tom Ogilvy

"Martyn" wrote in message
...
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"?


"Robert Rosenberg" wrote in message
...
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.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"Martyn" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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


"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Martyn" wrote in message
...
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"?


"Robert Rosenberg" wrote in message
...
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.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"Martyn" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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

"Chip Pearson" wrote in message
...
Martyn,

Does CTRL+Spacebar bring up the list of items?


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


"Martyn" wrote in message
...
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"?


"Robert Rosenberg" wrote in message
...
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.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"Martyn" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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" wrote in message
...
Yes it does...
Shame on me!. I must have been confused by the variable names.
Sorry to take everyones time.

"Chip Pearson" wrote in message
...
Martyn,

Does CTRL+Spacebar bring up the list of items?


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


"Martyn" wrote in message
...
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"?


"Robert Rosenberg" wrote in message
...
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.

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"Martyn" wrote in message
...
Thanks Robert but "Auto List Members" is already checked.

Why did XL stopped showing me the Macro Commands List
 

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" wrote in message
...
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

Why did XL stopped showing me the Macro Commands List
 

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 *

"Martyn" wrote in message
...
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" wrote in message
...
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

Why did XL stopped showing me the Macro Commands List
 

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

"A.W.J. Ales" wrote in message
...
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