Sub function Excel VBA

Question

Why would this be a syntax error? it is asking for an = sign

cyberlinkcompute("A1","B2")

private sub cyberlinkcompute ( a as string, b as string)

end sub

isnt a sub function something that does not need an =? thanks in advance

Uae cyberlinkcompute "A1","B2"instead. Here's an interesting post. — Doug Glancy
– Doug Glancy, Commented Jul 11, 2013 at 12:56

AMissico · Accepted Answer · 2013-07-11 12:55:34Z

2

Remove the parentheses or put the word Call in front of the procedure name

answered Jul 11, 2013 at 12:55

AMissico

21.8k7 gold badges80 silver badges108 bronze badges

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

Comments

Alex K. · Accepted Answer · 2013-07-11 12:55:25Z

1

Its the function-like parentheses it dislikes so either;

cyberlinkcompute "A1","B2"

or less advisably:

call cyberlinkcompute("A1","B2")

answered Jul 11, 2013 at 12:55

Alex K.

177k32 gold badges276 silver badges299 bronze badges

2 Comments

JosieP Over a year ago

for my own interest, why is call less advisable?

AMissico Over a year ago

I use the Call syntax when creating libraries because it is much easier to migrate the library code to VB or VB.NET. To migrate to VB, the syntax does not change. To migrate to VB, just remove the Call keyword.

Collectives™ on Stack Overflow

Sub function Excel VBA

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related