function arguments

[Dryver14]

I will probably be here a few times over the next few weeks to get answers to the stuff I am learning.

Function REMOVE(Txt as string) As string

Why 2 As Strings?

 

[shg]

The first specifies the data type of the argument and the second specifies the data type of the return value.

 

[Dryver14]

Thank you

if I used Function REMOVE(Txt) As String then the (Txt) is a variant

 

[shg]

Is that a question?

 

[shg]

Sorry -- yes, that's correct, and there are times you'd want to use a Variant, but my practice is to always be explicit as to data type.

And unless you need a Variant, it's better practice (faster, smaller memory footprint) to use strongly-typed variables.

 

[Dryver14]

No worries, it was kind of a rhetorical question, Thanks for response. I will try and use specific variable types unless of course the answer could be different types of response.