Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Using "Find" function in Excel 2000, edit data without closing Fin | Excel Discussion (Misc queries) | |||
Does Excel 2000 have the "List" data function like in Excel 2003 | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Can you use the validate function in a data form in Excel? | Excel Worksheet Functions |