Possible to store and use a comparison operator in a variable?

[axel67]

Hi,
Does anyone know if it is possible to store comparison operators like "<=" in a variable and use them later in a comparison statement?

Example:
Function CellCompare(FirstCell As Range, SecondCell As Range, CompareOperator As Range)
'compare operator can be "=", "<>", "<=",.....

CellCompare = (FirstCell.Value & CompareOperator.Value & SecondCell.Value)
'should return true of false dpending if condition is met

End Function


This breaks my head for some hours now. Thanks for any hints.
Cheers,
Axel

 

[Fenrirshowl]

How about

Function CellCompare(cell1, cell2, operator)
CellCompare = Evaluate(cel1 & operator & cel2)
End Function

Fen

 

[Fenrirshowl]

dammit - typos

Function CellCompare(cell1, cell2, operator)
CellCompare = Evaluate(cel[COLOR=red][b]l[/b][/color]1 & operator & cel[COLOR=red][b]l[/b][/color]2)
End Function

 

[axel67]

Thanks to all!
This works great for numeric expression (my main purpose). I will have a look with the evaluate function, if it is possible to do also a textual comparison.

Cheers,
Axel