[AccessD] [EXTERNAL] Re: Parameter (argument) order

[Stuart McLachlan]

And this CHatGPT response is totally incorrect:
"can you pass an array byval in VBA "

In VBA, arrays are passed by reference (BYREF) by default, but you can pass an 
array by value (BYVAL) by using the ByVal keyword when passing the array as an 
argument to a function or subroutine. 
In VBA, arrays are passed by reference (BYREF) by default, but you can pass an 
array by value (BYVAL) by using the ByVal keyword when passing the array as an 
argument to a function or subroutine. 


On 17 Feb 2023 at 16:12, Shane Groff via AccessD wrote:

> 
> Yes, it is impressive. However, you need to use your own judgment, it
> cannot always be trusted.
> 
> For example, this is not true, "Note that when passing arrays to a
> function, you need to make sure that the arrays are of the same data
> type and have the same number of elements."
> 
> Shane
> 
> ________________________________