IntelliSense Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glen - 25 Jan 2006 14:30 GMT

Hello, I just switched to a new Desktop at work with Excel 2003. My
Intellisense property lists do not appear in VBA and I am having
trouble finding out how to activate it. Any suggestions? Thanks in
advance.

Reply to this Message

Tom Ogilvy - 25 Jan 2006 14:47 GMT

In the VBE, in tools=>Options on the first tab (Editor) in the Code Settings
Frame, are the last 3 "Auto" options checked?

Signature

Regards,
Tom Ogilvy

> Hello, I just switched to a new Desktop at work with Excel 2003. My
> Intellisense property lists do not appear in VBA and I am having
> trouble finding out how to activate it. Any suggestions? Thanks in
> advance.

Reply to this Message

Glen - 25 Jan 2006 16:32 GMT

Thank you for your response Tom. The first thing I checked were the
options under Tools and yes they are checked. Do you have any other
suggestions?

Reply to this Message

Tom Ogilvy - 25 Jan 2006 17:57 GMT

If none are working, then no.

If some are and some are not, then I would say look an make sure you have
the proper object libraries referenced (and in tools=>references, nothing
shown as MISSING) and that your variables are declared with the proper type.
Make sure you have declared local names/variables which mask standard ones.
all just guesses of course.

Signature

Regards,
Tom Ogilvy

> Thank you for your response Tom. The first thing I checked were the
> options under Tools and yes they are checked. Do you have any other
> suggestions?

Reply to this Message

Glen - 25 Jan 2006 19:01 GMT

Thanks for your help Tom. I just inherited this PC from another user
so I ended up checking for updates for office and windows and found
some errors with office. Oddly enough, I patched Office and it works
fine. Sorry to have wasted your time.

Sincerely,
Glen

Reply to this Message