Using public function from userform

**Geronimo** · 09-01-2010, 03:26 AM

Hi!

I have this boolean function:

Please Login or Register  to view this content.

which is used to determin whether the date d1 is is a national holiday. This function works well when using it from a test-sub in the same module:

Please Login or Register  to view this content.

But, when I try to use it from within a userform, I get the error message "Compile error: ByRef argument type mismatch". The code I use in the userform is (extract):

Please Login or Register  to view this content.

What can be the reason for this? The d1 variable is declared as date both places...

Thx in advance for any help!

**T-J** · 09-01-2010, 05:56 AM

It's because dato is a Variant.

**snb** · 09-01-2010, 06:05 AM

or

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**romperstomper** · 09-01-2010, 07:22 AM

If the date is not found, then trying to access the address will return a run time error.

**Geronimo** · 09-01-2010, 07:56 AM

Update:
Thanks for all help :-)
I found a quick fix for my problem - just by adding a "ByVal" in the definition of the public function (I think "ByRef" is default?).

Please Login or Register  to view this content.

Case solved :-)

**romperstomper** · 09-01-2010, 08:53 AM

Please mark the thread 'Solved' then.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save