Welcome Guest
( Log In | Register )
The time is now 9:24 pm
You last visited August 18, 2017, 7:49 pm
All times shown are
Eastern Time (GMT-5:00)

Create an Excel UDF (User Defined Function)

Published:

Last Edited: October 28, 2009, 7:21 pm

Instructions for creating a UDF (User Defined Function) in Excel

How to Create Excel User Defined Functions

  1. Open up a new workbook.
  2. Get into VBA (Press Alt+F11)
  3. Insert a new module (Insert > Module)
  4. Copy and Paste the Excel user defined function examples -
  5. Get out of VBA (Press Alt+Q)
  6. Use the functions (They will appear in the Paste Function dialog box, Shift+F3, under the "User Defined" category)
Entry #122

Comments

This Blog entry currently has no comments.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.