Are variants automatically passed ByRef?

[mtnbiker98]

Hello,

My understanding of VBA is that values are automatically passed to functions by value, not by reference. However, in the following code, when I modify ctrRole, the data which I passed to that parameter also gets modified leading me to believe that the variant type is passed ByRef by default. Any input would be appreciated. Thank you!

Please Login or Register  to view this content.

[Kyle123]

VBA default is ByRef. VB.Net is ByVal, though it's often useful to specify this explicitly - have a read here: http://www.cpearson.com/excel/byrefbyval.aspx

[Norie]

By default arguments are passed ByRef.

[mtnbiker98]

Alright, good to know! That is why i love this forum. Thanks for your help!