Get out of VBE and back to the Excel window.

On the Toolbar click on the fx icon.

That is where you find "user defined" list of functions.

Whichever UDF's you have installed in your workbook or add-in will
show up there.

You should also be able to find them in a module when in VBE.


Gord

On Thu, 11 Aug 2011 14:21:52 -0700 (PDT), Ty
wrote:

On Aug 11, 9:27*am, Gord wrote:
You don't "run" functions.

Gord

On Thu, 11 Aug 2011 05:07:37 -0700 (PDT), Ty
wrote:



I have the code in Visual Basic. *This is a post of me not knowing how-
to use the code and execute it. *I don't know how to run it.- Hide quoted text -

- Show quoted text -

Gord, Correct. Functions are not ran. I'm still learning or
refreshing my memory and reading. "..A function is a pre-set formula
which can be written directly into a cell, to display an
outcome....etc..."

Gord! I don't see function(or User Defined) in Visual Basic. I had
to copy(drag it) the function I needed in this thread from the sample
to my VBAProject. When I click on Insert, I have:

1. Procedure
2. UserForm
3. Module
4. Class Module
5. File

After I dragged it, I right click on Functions and it has a REMOVE
Functions.

The Function shows up under Modules and then Functions in the Sample.
I searched the Excel help.. It has an example"Writing a Function
Procedure" with a sub that has a function but do not say how to create
a function.