VBA: Unexpected Behavior In IF-statement.

Question

I am using VBA for Microsoft Excel 2007. My code is as follows:

 Sub First()

 End Sub

 Function Two() As Boolean

 End Function

 Sub Sun()
     If (Two()) Then
         First()
     End If
 End Sub

What is wrong with this code? Why does it not compile?

Can I not use subs in IF statements? Is it a magic of VBA? How can or should I resolve this issue?

qxn · Accepted Answer · 2012-05-07 17:21:33Z

3

Try removing the parenthesis from the call to First.

Sub First()

End Sub

Function Two() As Boolean

End Function

Sub Sun()
    If (Two()) Then
        First
    End If
End Sub

answered May 7, 2012 at 17:21

qxn

17.6k3 gold badges55 silver badges72 bronze badges

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

3 Comments

gaussblurinc Over a year ago

thanks! and if First(arg as Variant) i must write First arg, yes?

qxn Over a year ago

@loldop -- I think so. VBA has some strange argument requirements. If the sub/function returns a value, and that value is placed in a variable, then parenthesis are required. If no value is returned, then you have to omit the parenthesis.

Dick Kusleika Over a year ago

Here's a nice write up of parentheses by Rick Rothstein. dailydoseofexcel.com/archives/2012/05/01/…

Nick Spreitzer · Accepted Answer · 2012-05-07 17:21:05Z

0

This compiles:

Sub First()

End Sub

Function Two() As Boolean

End Function

Sub Sun()
    If (Two()) Then
        First
    End If
End Sub

You need to remove the parentheses from your First call.

answered May 7, 2012 at 17:21

Nick Spreitzer

10.6k5 gold badges41 silver badges59 bronze badges

Collectives™ on Stack Overflow

VBA: Unexpected Behavior In IF-statement.

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related