Newbie-ish Class Module Sub Question

[zaimor]

Hello again.

I'm playing with custom classes, and I've created a method in one that looks like this:

Please Login or Register  to view this content.

I have a different class, where the Populate method does NOT have the optional argument, that works just fine. (as does this one, if I remove the optional argument)

When I try to use it as such:

Please Login or Register  to view this content.

I get a a compile error, Expected: =

I'm not setting or assigning anything, and the sub doesn't return a value, so where (more importantly, why) does the VBE want an =?

Edit: Because I have another class with a Public Sub Populate, I changed the one in question to PopulateIP, in case the duplicate name would be an issue. It did not fix the problem. (Bonus question: Since these are public subs in class modules, DO they need to be different names? Or can I have multiple classes with custom methods of the same name?)

Edit: When trying to call the method without the optional argument, VBE does not complain.

[Norie]

Try removing the ().

[OllieB]

I think it is because of the brackets surrounding the parameters passed. Two options

Please Login or Register  to view this content.

[zaimor]

That was it. Why does clsName.Populate(arg) work but clsName.Populate(arg1,arg2) not?

[JosephP]

unless you are returning a value from a function or using the Call statement (or explicitly trying to dereference a variable) you should not use parentheses. when you write

Please Login or Register  to view this content.

everything in the parentheses is treated as one argument

[zaimor]

Good information, just started learning VBA last month. Thanks for the tip!