+ Reply to Thread
Results 1 to 5 of 5

if function implementation

  1. #1
    Registered User
    Join Date
    05-09-2011
    Location
    ist
    MS-Off Ver
    Excel 2003
    Posts
    2

    if function implementation

    hello,

    how can we implement the excel's built-in "IF" function in vba?

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: if function implementation

    Hi and welcome to the board

    Best Google around a bit, you will find many examples

  3. #3
    Registered User
    Join Date
    05-09-2011
    Location
    ist
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: if function implementation

    Thank you for your welcome message.

    i googled it, but couldnt find anything about what i am looking for.
    as you know, you can use nested if functions.
    what i want to know is, how would we write our own IF function, if there wasnt any built-in IF ?

  4. #4
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: if function implementation

    See the below thread. You can find IF used at certain places

    https://www.excelforum.com/showthread.php?t=773089
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  5. #5
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: if function implementation

    Or if you really want to use the worksheet function IF then it can be something like
    Please Login or Register  to view this content.
    or certain worksheet fuunctions are available with
    Please Login or Register  to view this content.
    in VBA

    But as arthurbr advised, you can find lots and lots of examples with google search or if you spend a little time on surfing this forum

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1