ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I add a new formula to Excel formula list (https://www.excelbanter.com/excel-worksheet-functions/48471-how-can-i-add-new-formula-excel-formula-list.html)

Darafsh

How can I add a new formula to Excel formula list
 
I need add a new formula developed by myself to the available list of Excel
formula. My Excell version is 2003

Gary L Brown

I'm assuming you mean 'Function'.

If your User Defined Function is in a currently open workbook OR in your
'Personal.xls' workbook OR in an add-in you've created, you will be able to
use it by selecting...
Insert / Function
Highlight either 'ALL' or 'User Defined' in the "Function Category" window
Scroll down until you see your UDF in the "Function Name" window.
Highlight the UDF and select 'OK'

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Darafsh" wrote:

I need add a new formula developed by myself to the available list of Excel
formula. My Excell version is 2003



All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com