LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default User-Defined Excel Functions

Anyone know where I can find info on creating user defined
excel fuctions?

Just as a rudimentary example:
---------------------
Public Function Test(ByVal dAmt As Double) As Double

Test = dAmt * 2

End Function
------------------
This returns the "#VALUE!" error message. Never done an
excel UDF, so I've no idea what I'm doing wrong (or even
right).

Thanks in advance,

Sean
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
does Excel 07 allow User Defined functions? doc_grandma Excel Worksheet Functions 1 September 21st 09 11:16 PM
How to add user defined functions in excel permanantly Sandeep Jangra Excel Discussion (Misc queries) 2 October 10th 08 09:44 AM
I have had difficulty in creating user defined functions in Excel MichaelG Excel Worksheet Functions 3 July 13th 05 11:59 AM
Excel user defined functions. Matt Excel Worksheet Functions 4 March 15th 05 07:22 PM
Help for User Defined Functions in Excel 2003 Beta R Kalal Excel Programming 0 July 29th 03 04:58 PM


All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"