Use Logical Operators as Parameters in a VBA function

As the title says, I am trying ot find a way to have a user input logical operators into a function similar to how you can do with the worksheet functions countifs and sumifs. Ex:

Please Login or Register  to view this content.

If a user inputted "<=", I am having difficulty finding how to pull out "<=" from the string to have VBA understand it as logical operator and not a string.

Thank you for the assitance!

Use Evaluate method, see in VBA inner help …

Hey marc,

Thank you for the response.

Would you be able to provide an example? I checked out the evaluate method, and I am unclear how to utilize it for my purposes.

To clairify, I am not attempting to evaluate a worksheet function. Rather, I am writing a custom function, and I want several of the parameters to contain logical operators such as ">=10" or "=F", etc. When those parameters are read into VBA, I need a way to split the string between the numeric or character value and the logical operators. I could use the instr() and the left() vba functions;however, that would store ">=" as a string, and vba would not interpret them as logical operators.

Thanks,

grazian2

Ra

Please Login or Register  to view this content.

Do you like ? So thanks to click on bottom left star « Add Reputation » !

Hey marc,

I'm not sure if you read my previous comment; however, I am not attempting to use any existing worksheet functions. Rather, I am attempting to write my own custom function that employs the same paramater logic as existing functions "Sumifs" and "Countifs"

-grazian2

Start to write your own function without any parameter so we can understand your needs …