All:

Is it possible to use UDFs in a worksheet's code section? If so, how?

I can't seem to get the functions to calculate when called from a
worksheet.

Thanks in advance.

The UDFs should be in a standard module, not in a sheet module. In VBA: InsertModule

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Floyd Bates" wrote in message ups.com...
| All:
|
| Is it possible to use UDFs in a worksheet's code section? If so, how?
|
| I can't seem to get the functions to calculate when called from a
| worksheet.
|
| Thanks in advance.
|

Hi Floyd,

Why would you want to put a udf in a sheet module?

As a rule of thimb, use the worksheet module only for worksheet event code.



---
Regards,
Norman



"Floyd Bates" wrote in message
ups.com...
All:

Is it possible to use UDFs in a worksheet's code section? If so, how?

I can't seem to get the functions to calculate when called from a
worksheet.

Thanks in advance.

My boss wants to have each worksheet as a standalone entity, so that
others can move the worksheets into their workbooks without having to
import/export a VBA module.

Barring rules of thumb, is it possible?





Norman Jones wrote:
Hi Floyd,

Why would you want to put a udf in a sheet module?

As a rule of thimb, use the worksheet module only for worksheet event code.



---
Regards,
Norman



"Floyd Bates" wrote in message
ups.com...
All:

Is it possible to use UDFs in a worksheet's code section? If so, how?

I can't seem to get the functions to calculate when called from a
worksheet.

Thanks in advance.

Hi Floyd,

Try, instead, putting your udf's in an addin.


---
Regards,
Norman



"Floyd Bates" wrote in message
ups.com...
My boss wants to have each worksheet as a standalone entity, so that
others can move the worksheets into their workbooks without having to
import/export a VBA module.

Barring rules of thumb, is it possible?





Norman Jones wrote:
Hi Floyd,

Why would you want to put a udf in a sheet module?

As a rule of thimb, use the worksheet module only for worksheet event
code.



---
Regards,
Norman



"Floyd Bates" wrote in message
ups.com...
All:

Is it possible to use UDFs in a worksheet's code section? If so, how?

I can't seem to get the functions to calculate when called from a
worksheet.

Thanks in advance.