Assigning a function to excel cell

February 17, 2009 at 20:59:48
Specs: Windows XP

I am trying to assign a user defined VB function to excel cell.

I wrote a s simple function called testy() in VB editor that returned a number.

Function testy() As Single
testy = 2.4
End Function

But when I assign excel with thus function like this,

I get a cell error #NAME?

What I am doing wrong.

See More: Assigning a function to excel cell

Report •

February 18, 2009 at 06:28:29
It works for me...

Where did you store it?

UDF's need to be stored in a regular module, not in a sheet module or in the ThisWorkbook module.

Report •
Related Solutions

Ask Question