Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical test as a variable in a UDF
Hello - Is it possible to pass a logical test through a variable? For example:
function testFunc(A as integer, test as String, B as integer) if (A test B) then testFunc = "A is greater than B" else: testFunc = "A is not greater than B" end if end function And entered like so in the spreadsheet: =test(2,"",1) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical test as a variable in a UDF
Maybe...
Option Explicit Function testFunc(A As Integer, test As String, B As Integer) testFunc = Application.Evaluate(A & test & B) End Function Sub testme() MsgBox testFunc(2, "", 1) End Sub Dave wrote: Hello - Is it possible to pass a logical test through a variable? For example: function testFunc(A as integer, test as String, B as integer) if (A test B) then testFunc = "A is greater than B" else: testFunc = "A is not greater than B" end if end function And entered like so in the spreadsheet: =test(2,"",1) -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical test as a variable in a UDF
Worked perfect, thanks!
"Dave Peterson" wrote: Maybe... Option Explicit Function testFunc(A As Integer, test As String, B As Integer) testFunc = Application.Evaluate(A & test & B) End Function Sub testme() MsgBox testFunc(2, "", 1) End Sub Dave wrote: Hello - Is it possible to pass a logical test through a variable? For example: function testFunc(A as integer, test as String, B as integer) if (A test B) then testFunc = "A is greater than B" else: testFunc = "A is not greater than B" end if end function And entered like so in the spreadsheet: =test(2,"",1) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use 'CONTAINS' in an IF Logical Test? | Excel Worksheet Functions | |||
Logical Test | Excel Worksheet Functions | |||
logical test | Excel Worksheet Functions | |||
logical test | Excel Worksheet Functions | |||
Logical test | Excel Discussion (Misc queries) |