Trouble implementing UDF's

[ProspectiveCounselor]

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

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--

[Admin]

Hi Sabrina,

Welcome to ExcelFox !!

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

[ProspectiveCounselor]

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

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

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.




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.

[Admin]

Hi,

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

[ProspectiveCounselor]

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!