| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing user to choose to accept saveas option | Excel Discussion (Misc queries) | |||
| Locking a worksheet, but allowing user to add rows in a table | Excel Worksheet Functions | |||
| How do I protect a number of sheets allowing the user to add a com | New Users to Excel | |||
| Allowing user to merge cells | Excel Discussion (Misc queries) | |||
| allowing user to format a protected cell | Excel Programming | |||
![Paul987[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
