• VBA/VB and IIF Statement (Office XP)

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » VBA/VB and IIF Statement (Office XP)

    • This topic has 11 replies, 8 voices, and was last updated 23 years ago.
    Author
    Topic
    WSMelanieB
    AskWoody Lounger
    June 22, 2002 at 3:33 am #372671

    We are going to upgrading from Office 97 to Office XP. I understand that XP uses VB6 instead of VBA. I have two questions: (1) What do you lose when you convert from VBA to VB? What commands won’t work anymore? (2) How does VB Handle the IIF command? Does it convert to something else?

    Reply | Quote
    Viewing 2 reply threads
    Author
    Replies
    • WSMarkJ
      AskWoody Lounger
      June 22, 2002 at 3:59 am #596388

      Where did you get this information?

      Office XP still uses VBA.

      AFAIK, IIF is a function that belongs only to Access. That function is still alive and well in Access 2002 (XP).

      HTH

      Reply | Quote
      • WSHoward Kaikow
        AskWoody Lounger
        June 22, 2002 at 3:04 pm #596416

        IIF is part of VBA, nothing Access dependent.

        Reply | Quote
        • WSBrooke
          AskWoody Lounger
          June 22, 2002 at 6:02 pm #596422

          Yes and no:

          IIf is a VBA function that – AFAIK – can be used in all applications that support VBA. But Access is the only application I know of that you can use it in without touching a VBA code module. So to me, although it may just be the equivalent of Excel’s IF, since you can’t use the same name in both applications it is “special” to Access.

          Reply | Quote
          • WSHoward Kaikow
            AskWoody Lounger
            June 22, 2002 at 10:04 pm #596446

            IIF Can be freely used with VBA.
            If you look at the Help, or Object Browser, in Access VBA, you will find IIF defined as it is for all other VBA apps.

            Reply | Quote
            • WBell
              AskWoody_MVP
              June 23, 2002 at 1:01 am #596472

              Brooke’s point is that you can also use it in SQL statements which nothing to do with VBA, making Access unique in that respect.

              Reply | Quote
            • WSHoward Kaikow
              AskWoody Lounger
              June 23, 2002 at 5:57 am #596481

              Yes, but this thread is about VB/VBA.

              Reply | Quote
            • WSdavid
              AskWoody Lounger
              June 23, 2002 at 7:11 am #596484

              The original question is “How does VB Handle the IIF command? “. I dont feel any special for VB handling IIF function than VBA or Access. I used it several times in my VB6 applications (with NZ function) to covert Null to something, nothing wrong, nothing special. Although my DB is Access, the part of code I use IIF doesnt deal with DB directly. I m not sure it is a must to link Access for using IIF. If you check MSDN of VB6 for IIF fuction, it doesnt mention anything abt ACCESS.

              Reply | Quote
            • WSBrooke
              AskWoody Lounger
              June 23, 2002 at 11:40 am #596489

              A valid point! grin I was just trying to clarify – sorry if that went wrong.

              Reply | Quote
            • WScharlotte
              AskWoody Lounger
              June 23, 2002 at 2:45 pm #596502

              No need to apologize. You can’t separate VB and VBA that neatly.

              Reply | Quote
    • WSGary Frieder
      AskWoody Lounger
      June 22, 2002 at 5:25 am #596390

      Perhaps the confusion arises because the ‘VB’ part of Office 97 VBA is VB5, while the ‘VB’ part of VBA in Office 2000/Office XP is VB6.

      So you’re not losing anything in moving from Office 97 VBA to Office XP VBA; VB6 has some features that VB5 lacks (rather than the other way round).

      The IIf function is definitely a built in function in VB6 and you should be able to continue to use it as is.

      Gary

      Reply | Quote
    • WSHoward Kaikow
      AskWoody Lounger
      June 22, 2002 at 3:06 pm #596417

      Note that IIF executes more slowly than the equivalent If THen Else AND could have side-effects as both alternatives are evaluated, not just 1.

      Reply | Quote
    Viewing 2 reply threads
    Reply To: VBA/VB and IIF Statement (Office XP)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.