Trouble implementing UDF's

Hello,

I'm new to UDF's since my interest in them came only a few hours ago. I'm having trouble implementing them. I once was able to just use A1 = padLeft("x",5)&":" to get

Code:

---

x    :

---

but now I sometimes get a #NAME error on that. I was able to do it using PadLeft.PadLeft("x",5), but I don't want to have to do that. I think maybe the first PadLeft (before the dot) is the module name, but I didn't have to use the module name before I renamed it. How do I get standard access to it?

--Sabrina--

Hi Sabrina,

Welcome to ExcelFox !!

Your code is incomplete, I guess. Post your whole code.

I don't think it's the code because only the method of calling it is the problem. Here is my code, though.

PadLeft, in Module called PadLeft

Code:

---

Function PadLeft(text, spaces)
    If Len(text) <= spaces Then
        PadLeft = Application.Rept(" ", spaces - Len(text)) & text
    Else
        PadLeft = text & " has " & Len(text) & " space(s). You are asking for " & spaces & " space(s)."
    End If
End Function

---

PadRight

Code:

---

Function PadRight(text, spaces)
    If Len(text) <= spaces Then
        PadRight = text & Application.Rept(" ", spaces - Len(text))
    Else
        PadRight = text & " has " & Len(text) & " space(s). You are asking for " & spaces & " space(s)."
    End If
End Function

---

Like I said, calling padleft("A",5) doesn't work, but calling PadLeft.PadLeft("A",5), does; calling padRight("A",5) doesn't work, as well, while PadRight.PadRight("A",5) does.

Here are print screens depicting what I'm doing.

http://www.fileden.com/files/2012/10...f_formulas.png
http://www.fileden.com/files/2012/10...udf_values.png

I apologise for the size, but I don't have time to resize them atm because I have a term paper due in less than six hours.

Hi,

Change your module name. Your UDF as well as function name are same, which causes the problem.

OK, that fixed the problem, I think. I say "I think" because I was getting a popup saying "User function type not defined" or something like that, but restarting Excel a couple of times fixed that. Thank you!