Autocomplete (?) in code not working

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Your assistance please...

Usually when writing code a drop down would appear after adding "."
like Activecell.
but suddenly it is not there. (sorry I don't remember what it is called)

Can anyone steer me in the right direction as to fix this.

It has happened with both Excel97 & Excel 2k on my machine.

I checked the Tools > Options and all the Code Settings are checked.

thanks in advance...
 
It is called autolist members under the tools=>Options menu in code
settings. You say all these are checked and you say you always use option
explicit, so your objects are declared. I can't say what is causing the
problem. Perhaps close excel, clean out your temp directories and reboot.
You may have to reinstall office <g>. But I would next try to reregister by
going to the run option under the start menu and do

excel.exe /unregserver
then again with
excel.exe /regserver
 
Tom,

Followed your instruction. And no luck. Guess I'll have to reload.

But a thought - recently had 97 and 2k loaded (in different folders) on my
machine and they were both doing OK. Now neither shows the autolist.
Do you think that the problem might be there???

Be aware that
Option Explicit is Always on
Variables are declared
All temp folders and recycle bin are cleaned at least once a day
(sometimes more) (my Internet Temp fills up fast).
All Options are checked. Tried unchecking and rechecking to make
sure.
I do get the Auto Quick tips!!!

Did the 'run' thing both before and after I rebooted.

Sure miss that list!!!

Thanks for your help and patience!!!
--
sb
Tom Ogilvy said:
It is called autolist members under the tools=>Options menu in code
settings. You say all these are checked and you say you always use option
explicit, so your objects are declared. I can't say what is causing the
problem. Perhaps close excel, clean out your temp directories and reboot.
You may have to reinstall office <g>. But I would next try to reregister by
going to the run option under the start menu and do

excel.exe /unregserver
then again with
excel.exe /regserver
Click to expand...
 
If you want to find the cause, then I think you will have to retrace your
steps and find out what changed during the period when the lists stopped
showing up. This would be useful in any event, because unintalling Office
doesn't necessarily clear out everything, so you could have some residual
environment stuff left (which could be the culprit).

--
Regards,
Tom Ogilvy




steve said:
Tom,

Followed your instruction. And no luck. Guess I'll have to reload.

But a thought - recently had 97 and 2k loaded (in different folders) on my
machine and they were both doing OK. Now neither shows the autolist.
Do you think that the problem might be there???

Be aware that
Option Explicit is Always on
Variables are declared
All temp folders and recycle bin are cleaned at least once a day
(sometimes more) (my Internet Temp fills up fast).
All Options are checked. Tried unchecking and rechecking to make
sure.
I do get the Auto Quick tips!!!

Did the 'run' thing both before and after I rebooted.

Sure miss that list!!!

Thanks for your help and patience!!!
--
sb
Tom Ogilvy said:
It is called autolist members under the tools=>Options menu in code
settings. You say all these are checked and you say you always use option
explicit, so your objects are declared. I can't say what is causing the
problem. Perhaps close excel, clean out your temp directories and reboot.
You may have to reinstall office <g>. But I would next try to
Click to expand...
reregister
Click to expand...
 
Tom,

Again - much thanks. I'll start looking...

My only concern now is that it was working before I went home yesterday
and I haven't changed anything (that I know of).
 
Tom,

Success! Still am not sure what the culprit was, but found this
Started dummy code and typed 'application' and as soon as I entered
the '.' the autolist appeared. Any thoughts?
It wasn't working with other objects, but now is...

Also found a Temp folder (I had overlooked) and it was stuffed.
Cleared it out (after the above).

Its still a mystery - but fixed (for now).

Your advice helped... Thanks!
 
Tom,

A quick follow up...

The problem resurfaced. The computer had been shut down over the
weekend and after booting up - there it was.

Typing
Application.
into the code window restored the autolist.

Also notice that Excel takes a very long time to load the first time after
turning the computer back on.

Any thoughts?

Be aware that all this has started since installing both 97 & 2k on the
computer (but in different folders).
 
Back
Top