Help to Create Excel Function using VBA to analyze data
 

I am trying to create a function using Excel VBA that looks at each argument
and does validation of the argument to determine whether or not to include
the argument in the min function. The validation process should exclude
arguments that:

Argument = 0
Argument is text
Argument is an error

If the all the arguments fail the validation, it should return a text
message ie €œItem not bid€� otherwise it should return the result of the min
value of the arguments that pass the validation process. Any help would be
much appreciated. I also want to create a function the works similar using
€œSmall€�.

Thanks,

bob


Function MinPrice(ParamArray arglist() As Variant) As Double
For Each arg In arglist
MinPrice = WorksheetFunction.Min(arglist)
Next arg
End Function

Help to Create Excel Function using VBA to analyze data
 

See your other post.

Bob K wrote:

I am trying to create a function using Excel VBA that looks at each argument
and does validation of the argument to determine whether or not to include
the argument in the min function. The validation process should exclude
arguments that:

Argument = 0
Argument is text
Argument is an error

If the all the arguments fail the validation, it should return a text
message ie €œItem not bid€� otherwise it should return the result of the min
value of the arguments that pass the validation process. Any help would be
much appreciated. I also want to create a function the works similar using
€œSmall€�.

Thanks,

bob

Function MinPrice(ParamArray arglist() As Variant) As Double
For Each arg In arglist
MinPrice = WorksheetFunction.Min(arglist)
Next arg
End Function

--

Dave Peterson

Help to Create Excel Function using VBA to analyze data
 

Dave

I can not find my previous post, so I reposted it again. I created a
function that provided me with the min value, but I am not sure how to write
the code to validate each of the arguements that flow through (agruement = 0,
arguement = text, arguement = error code. I am trying to teach myself VBA,
but I am very new to it. Any help would be much appreciated.

thanks,

bob k

"Dave Peterson" wrote:

See your other post.

Bob K wrote:

I am trying to create a function using Excel VBA that looks at each argument
and does validation of the argument to determine whether or not to include
the argument in the min function. The validation process should exclude
arguments that:

Argument = 0
Argument is text
Argument is an error

If the all the arguments fail the validation, it should return a text
message ie €œItem not bid€� otherwise it should return the result of the min
value of the arguments that pass the validation process. Any help would be
much appreciated. I also want to create a function the works similar using
€œSmall€�.

Thanks,

bob

Function MinPrice(ParamArray arglist() As Variant) As Double
For Each arg In arglist
MinPrice = WorksheetFunction.Min(arglist)
Next arg
End Function

--

Dave Peterson

Help to Create Excel Function using VBA to analyze data
 

Dave

I found your orginal response. Thanks, I am going to test it now.

bob k

"Bob K" wrote:

Dave

I can not find my previous post, so I reposted it again. I created a
function that provided me with the min value, but I am not sure how to write
the code to validate each of the arguements that flow through (agruement = 0,
arguement = text, arguement = error code. I am trying to teach myself VBA,
but I am very new to it. Any help would be much appreciated.

thanks,

bob k

"Dave Peterson" wrote:

See your other post.

Bob K wrote:

I am trying to create a function using Excel VBA that looks at each argument
and does validation of the argument to determine whether or not to include
the argument in the min function. The validation process should exclude
arguments that:

Argument = 0
Argument is text
Argument is an error

If the all the arguments fail the validation, it should return a text
message ie €œItem not bid€� otherwise it should return the result of the min
value of the arguments that pass the validation process. Any help would be
much appreciated. I also want to create a function the works similar using
€œSmall€�.

Thanks,

bob

Function MinPrice(ParamArray arglist() As Variant) As Double
For Each arg In arglist
MinPrice = WorksheetFunction.Min(arglist)
Next arg
End Function

--

Dave Peterson