Posted to microsoft.public.excel.programming

external usenet poster

Posts: 11

Problem with the VBA / Excel interface

I'm just getting back to VBA for Excel, and I am now using Excel
2007. One thing in the VBA studio bothers me. The Intellisense
window sometimes does not pop-up. Usually, it fails to pop up after
the second level. For example, if I want to activate the first sheet
in the first book, I type "Workbooks(1).WorkSheets(1)". The
intellisense window does not come up to give me the properties and
methods exposed by the Worksheet. Can I change this?

Oddly, if I type "Dim s as Excel.Worksheet", then typing "s" will give
me the intellisense window that I want.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with Excel's COM interface in XLL	Mousam	Excel Programming	1	October 12th 07 02:44 PM
Problem Loading Addins - Excel Started through COM Interface	newbie73	Excel Programming	1	September 7th 07 07:30 PM
QUI Expert: Excel-based User Interface or OO User Interface?	Michael[_27_]	Excel Programming	1	November 11th 04 01:53 PM
GUI Expert: Excel-based User Interface or OO User Interface?	Michael[_27_]	Excel Programming	0	November 11th 04 01:20 PM
Web Enabled Excel Interface Problem	TerryG	Excel Programming	1	October 20th 04 09:12 PM

All times are GMT +1. The time now is 11:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us