Intellisense Tip (any)

Topic

New Reply

Just thought I’d pass this along even though most MS coders know this already.
But, just in case you missed it, you’ll be plenty happy to know this little trick:

When typing code, you can press Ctrl-[spacebar] to “force” intellisense to show
you the popup list of methods, constants, properties, etc. Sometimes, the IDE
will not automatically pop up the list like it does most of the time.

I don’t recall reading this anywhere (a friend showed me), but if it’s already floating around
in a Lounge post, my apologies for not searching first…

Reply | Quote

Replies

Unfortunately, it doesn’t work in the Excel VBE, where IntelliSense is less Intelli than in the VBE for Word or Access (can’t speak for the other Office apps)

Reply | Quote

That’s too bad. It’s really a handy item in Visual Studio and the Word IDE.

Reply | Quote

It certainly is, even in Excel. For instance, if InstelliSense shows the list of properties and methods, but you click elsewhere, it disappears, and doesn’t reappear automatically when you click after the dot. In such cases, Ctrl+space forces the list to reappear.

But in some cases, IntelliSense refuses to kick in, and then Ctrl+space doesn’t help either. For example:

Type “Workbooks(“. IntelliSense indicates that you must type an index.
Type “1).”. IntelliSense presents a list of properties and methods of the Workbook object.
Select Worksheets and press Tab.
Type “(“. IntelliSense again prompts you to type an index.
Type “1).”. Nothing

Hmm, I’m starting to sound like somebody else. Better stop.

Reply | Quote

Woah. That is deficient. And it gets weirder (more weird?) I see:
Type anything instead of a period (then Ctrl+space) and you’re back to the
application level. Now that’s real handy!

Now try Ctrl+space right after the ) — Workbook members!

The good new is that in VS, the Office object members (via the PIAs) show up
as tooltip text and the project members show up in the pop up. That’s a
definite improvement.

Reply | Quote

Man, I LOVE the search facility!

Reply | Quote

Man, I LOVE the search facility!

Reply | Quote