Allowing user to choose what mathmatical operator macro uses
 

I want a simple marco to compare two cells, but the user to decide =, <
or . What is the best way to do this

--
Paul98
-----------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...fo&userid=2485
View this thread: http://www.excelforum.com/showthread.php?threadid=51737

Allowing user to choose what mathmatical operator macro uses
 

No need for VBA. Use a named formula.

Suppose your first (Left Hand Side) token is in A1, the operator of interest
in B1 and the 2nd (Right Hand Side) token in C1. Then, create a named
formula, named say Eval, with Insert | Name Define...

Eval =EVALUATE(Sheet1!$A$1&Sheet1!$B$1&Sheet1!$C$1)

In D1 enter =Eval

Change the values in A1:C1 and Eval will display the appropriate result.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I want a simple marco to compare two cells, but the user to decide =, <,
or . What is the best way to do this?


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=517379

Allowing user to choose what mathmatical operator macro uses
 

Thanks for the response. The named formula works well.


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=517379