Creating an If statement with a variable operator

I am not sure if this is possible, but can you create a dynamic if statement, where the operator is a variable?
I want to create a dropdown menu where the user can select an operator (=,<>,>,etc), and a macro will perform a validation based off of that selection.
Please let me know if you require any further details, or have any ideas.

Ex:
instead of something like:
If Variable1 = "Test" then...

I would like it to be something like:
If Variable1 VariableOperator1 "Test" then...

Hi,

EVALUATE is a function which can convert formula in string format to real function.
Try using something like:

Please Login or Register  to view this content.

Here say A1 has a value A2 is operator (>,< etc) and A3 is a value.

Hi Speshul and misrasomendra,
Thank you for your responses. I think that the Evaluate function is the direction I am looking towards. I will play around with the function and see if I can get it to work for my purposes. Cheers!

You can also use EVALUATE function in name manager through named formula, if the requirement is not much further in to macro. But then also you have to save the file as MACRO enabled .xlsm format.

If you feel the solution will help you than you can give reputation by clicking the reputation star below my comment

Hi Winon,
I actually think it will be less confusing if I show you what I intend to do, as the macro is quite large.
I want to take a text string similar to this:
{|Supplier|=|Pro|AND|Worker|=|Ryan|AND|Bill Rate|>|20|AND|Mark Up|=>|25|AND|OT Multiplier|=|25|}
And extract the individual data elements (I already have code for this).
Ex
If Supplier = Pro AND worker = Ryan ...

and then use these elements to validate data against. So, they would need to be put into some sort of IF statement. I think that the EVALUATE function might be able to be manipulated to make this work.
Each of those data elements can have between 5 and 30 choices in a dropdown menu, so a simple if statement doesn't make sense.

I hope I explained this well, but if you still would like to see a spreadsheet, I can make a sample for you.
Thanks in advance for any advice.

Originally Posted by Winon

Hello Rshwar23,

I find you request too wide to pinpoint it to an exact requirement.

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Regards.

Originally Posted by misrasomendra

Hi,

EVALUATE is a function which can convert formula in string format to real function.
Try using something like:

Please Login or Register  to view this content.

Here say A1 has a value A2 is operator (>,< etc) and A3 is a value.

Hi misrasomendra,
I tested it out, and it doesn't appear to do quite what I want. Any ideas?

Please Login or Register  to view this content.

Try below code:

Please Login or Register  to view this content.

Hi
misrasomendra,
That worked! Thank you. Just so I understand what the formula did, the """" just encloses each variable in quotation marks? So Excel would read it as Evaluate( "Pro" "=" "Pro" ) ?

Yes other wise the string would have been "Pro=Pro" so type mismatch.

Thank you again for your help. This will help me out quite a lot.