UDF not working.

  • Thread starter Thread starter Rao Ratan Singh
  • Start date Start date
R

Rao Ratan Singh

I m using User defined function in excel. it was working good in excel 2003
but not in excel 2007.

user defined function is -

Function GetDigit(Digit As String)
Dim CheckDigit As String
Dim looper
For looper = 1 To Len(Digit)
CheckDigit = Mid(Digit, looper, 1)
Select Case Val(CheckDigit)
Case 1: GetDigit = GetDigit & "G"
Case 2: GetDigit = GetDigit & "O"
Case 3: GetDigit = GetDigit & "L"
Case 4: GetDigit = GetDigit & "D"
Case 5: GetDigit = GetDigit & "E"
Case 6: GetDigit = GetDigit & "N"
Case 7: GetDigit = GetDigit & "C"
Case 8: GetDigit = GetDigit & "I"
Case 9: GetDigit = GetDigit & "T"
Case 0: GetDigit = GetDigit & "Y"
Case Else: GetDigit = ""
End Select
Next
End Function

why is not working in excel 2007. hope this platform will solve my proble.

RRS
 
It worked for me.

Are you sure that you have macros enabled on that file? Check if there is an
options button in the formula bar.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
If it is that, it inserts a new bar just above the formula bar with some
text about a Security Warning, and it gives you an Options button to enable
the macros.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top