Objects as arguments to Sub

[Brunstgnegg]

Hello everyone

This should be a fairly basic and commonly asked question and I've searched both the web and here for a solution but have yet to find one.

What I want to do is create a Sub that takes an object ByRef.

This is my code

DateForm:

Please Login or Register  to view this content.

Here is where it's used:

Please Login or Register  to view this content.

I have also tried:

Please Login or Register  to view this content.

I get an Error 424 Object required in both cases. I suspect the error occurs because I send a copy instead of a ref or something like that but I really can't figure it out. I also tried using ByVal (which shouldn't really work) but I get the same error.

I get the error on this line:
DateForm.DisplayDateForm (DateBox)
i.e. when I call the function.

Thanks in advance

[romperstomper]

Remove the parentheses round the object when you pass it to the sub:

Please Login or Register  to view this content.

[Brunstgnegg]

*Smacks forehead*

Thanks

Move along people nothing to see here