how to use `if` worksheet function in vba?

Question

My code is as follows:

Function my_if() As Boolean
    my_if = Application.WorksheetFunction.If(True, True, False)
End Function

But I am getting #VALUE as a result. Why is that?

According to MSDN there is no If method in WorksheetFunction. See: [learn.microsoft.com/en-us/office/vba/api/…. Use IIF instead: [learn.microsoft.com/en-us/office/vba/language/reference/… — Peter1101
– Peter1101, Commented Oct 23, 2022 at 11:58
@PéterForgó thanks, the links not working because of the excessive brackets — Andrey
– Andrey, Commented Oct 23, 2022 at 12:04

John Coleman · Accepted Answer · 2022-10-23 11:56:02Z

1

If isn't one of the functions in the WorksheetFunction object. Rather than writing your own my_if function, just use the built-in VBA function IIF instead. Or, you could do:

Function my_if() As Boolean
    my_if = IIf(True, True, False)
End Function

answered Oct 23, 2022 at 11:56

John Coleman

52.1k7 gold badges59 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to use `if` worksheet function in vba?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related