Coffeehouse Thread

5 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

VBA intellisense

Back to Forum: Coffeehouse
  • User profile image
    JoshRoss

    I was looking at the new Office 2011 for Mac and I noticed that there is intellisense for VBA. Something like this would have been a big help to me when I was first learning VBA. The official site doesn't contain that much info on the product, it seems that there is mostly screen shots.

    Has anyone here used it? (The new VBA editor?)

  • User profile image
    magicalclick

    I just tested it out, yes. Office 2010 has intellisense. I really like they still improve the editor. One big reason I wish to use VS is because of the intellisense. And now, I can stay in Excel macro editor for good.

    Leaving WM on 5/2018 if no apps, no dedicated billboards where I drive, no Store name.
    Last modified
  • User profile image
    DCMonkey

    I think the Windows VBA editor has had some form of Intellisense since at least Office 2003 (at least for object methods).

  • User profile image
    magicalclick

    @DCMonkey:

    Come to think of it, I think you are right. Otherwise I wouldn't ba productive to begin with lol. I don't remember why I prefer VS. Something is missing in Excel editor. Gosh, I can't remember.

    One bad thing about excel editor is the syntax popup warning. Gosh, I wasn't done yet, not need to tel me I didn't do it right just yet.

    Leaving WM on 5/2018 if no apps, no dedicated billboards where I drive, no Store name.
    Last modified
  • User profile image
    spivonious

    , magicalclick wrote

    @DCMonkey:

    Come to think of it, I think you are right. Otherwise I wouldn't ba productive to begin with lol. I don't remember why I prefer VS. Something is missing in Excel editor. Gosh, I can't remember.

    One bad thing about excel editor is the syntax popup warning. Gosh, I wasn't done yet, not need to tel me I didn't do it right just yet.

    At least in 2003 you can turn that off. Tools->Options->uncheck Auto Syntax Check

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.