View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elena Elena is offline
external usenet poster
 
Posts: 43
Default Customized function

Hello,

I'm trying to write a simple function in VBA and to use it in the worksheet.
I do the following steps:
1. Alt+F11
2. Defining the function:
Function Koah(duration, percentage As Double) As Double
Koah = duration * percentage / 12
End Function

3. Closing VBA
But the name of the function doesn't appear in the list of "All" functions,
and excel don't recognize my customized function.

I tried to write a macro with this function - and it works, the problem that
I need to use the function without the macro.

Is it something Excel definitions?

Please help,