Re: What is the syntax for function text parameters in VBA (Excel
- From: Harlan Grove <hrlngrv@xxxxxxx>
- Date: Wed, 01 Aug 2007 12:44:22 -0700
Jocken <Joc...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote...
So I tried that like so:....
Function CONTAINS(within, test)
Dim within As String
Dim test As String
the compiler complains about a duplicate declaration.
Online help is your friend. Using it, you can find answers to problems
that could take days of back & forth with newsgroups postings.
Searching VBA help for the term Function does produce a lot of chaff,
but also the topic titled 'Function Statement'. The Example link in
that topic shows several examples, the first of which is:
Function CalculateSquareRoot(NumberArg As Double) As Double
If NumberArg < 0 Then ' Evaluate argument.
Exit Function ' Exit to calling procedure.
Else
CalculateSquareRoot = Sqr(NumberArg) ' Return square root.
End If
End Function
which shows that the proper syntax requires putting the type
declaration in the function's argument list.
what I want to say is "Function CONTAINS(String within,
String test)"; All I need is for VBA to set up a function that
expects two String-type parameters and does calculations with them.
And the online help examples show that your syntax is wrong. There are
many examples of proper syntax in online help. In MSFT BASIC dialects,
types are specified by APPENDING 'As' followed by the type name AFTER
the variable name.
I miss Java... *tear....
Most definitely VB* isn't Java, but you can't expect any language that
doesn't trace its ancestry to C to use C-like syntax. At some point
you have to sneak a peak at the language docs.
.
- Prev by Date: Re: getting rid of "#N/A" in columns
- Next by Date: Re: Mouse controlled auto sum feature lost
- Previous by thread: Re: Contains vs =
- Next by thread: Re: What is the syntax for function text parameters in VBA (Excel
- Index(es):
Relevant Pages
|
