Calling a public function from userform

I apologize in advance if this is a dumb question, or asked previously. I tried searching (and Googling) to no avail.

I was wondering how I can call a function (with 4 parameters, and returns a String) defined in the ThisWorkBook tab of my VBE, and call from a userform (specifically, when I click a button on the userform, I want it to use the public function to calculate something). I wanted to keep it separate because I will need to access the function from a 2nd userform later.

Thanks in advance!

I've actually tried using the

Please Login or Register  to view this content.

method, but again, it doesn't work. I've also tried putting the function in a module, also, no luck.

Let me go into a little more detail about what the function is.

I have a function that I copied from the web somewhere, that reads a string and the length it ought to be. Then it decides if the string needs to be padded by spaces to satisfy the length requirement (or truncate the string if it's too long).

I have a userform that gets some text from a user, and when I click a button, I want it to take in the input text, run it through the function for spacing and padding, and put it on a worksheet in the same workbook.

If I have to, I'll paste the function code in the userform tab but I think that's redundant if I have to access it from another userform later.

I'm a newbie at VB programming, learning everything from google and experimentation, and an ex-Java programming student 5 years ago, so maybe I'm missing something.

Any other ideas? Thanks in advance.