Results 1 to 6 of 6
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Intellisense Tip (any)

    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...
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Intellisense Tip (any)

    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)

  4. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intellisense Tip (any)

    That's too bad. It's really a handy item in Visual Studio and the Word IDE.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  5. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Intellisense Tip (any)

    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 <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

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

  6. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intellisense Tip (any)

    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.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  7. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intellisense Tip (any)

    Man, I LOVE the search facility!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •