| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a string to a function instead of a cell reference
Currently using excel2003 with the following UDF
Function EmpName(nam3 As String) Select Case nam3 Case "John" EmpName = "First" Case "Doe" EmpName = "Last" End Select End Function This works if I use a cell reference i.e. A1=John, =EmpName(A1) but fails if I use =EmpName(John). I can get both forms to work if I am passing a number and evalualting the case as a number. How do i get it to use =EmpName(John)? Thank you in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Passing a string to a function instead of a cell reference
"rbennu" wrote:
How do i get it to use =EmpName(John)? =EmpName("John") just you use strings in any Excel formula. ----- original messages ----- "rbennu" wrote: Currently using excel2003 with the following UDF Function EmpName(nam3 As String) Select Case nam3 Case "John" EmpName = "First" Case "Doe" EmpName = "Last" End Select End Function This works if I use a cell reference i.e. A1=John, =EmpName(A1) but fails if I use =EmpName(John). I can get both forms to work if I am passing a number and evalualting the case as a number. How do i get it to use =EmpName(John)? Thank you in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Passing a string to a function instead of a cell reference
Much Thanks!
"Joe User" wrote: "rbennu" wrote: How do i get it to use =EmpName(John)? =EmpName("John") just you use strings in any Excel formula. ----- original messages ----- "rbennu" wrote: Currently using excel2003 with the following UDF Function EmpName(nam3 As String) Select Case nam3 Case "John" EmpName = "First" Case "Doe" EmpName = "Last" End Select End Function This works if I use a cell reference i.e. A1=John, =EmpName(A1) but fails if I use =EmpName(John). I can get both forms to work if I am passing a number and evalualting the case as a number. How do i get it to use =EmpName(John)? Thank you in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| passing cell reference and formatting cell in VBA function | Excel Programming | |||
| error passing a formula to a cell from a string | Excel Programming | |||
| Passing Cell Address (String or Range) | Excel Programming | |||
| Passing a string aray as an argument to a function ?....Help! | Excel Programming | |||
| passing reference arguments to VBA function | Excel Programming | |||
Linear Mode
