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.
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.
In the VBE, in tools=>Options on the first tab (Editor) in the Code Settings
Frame, are the last 3 "Auto" options checked?
--
Regards,
Tom Ogilvy
"Glen" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
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?
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.
--
Regards,
Tom Ogilvy
"Glen" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks