Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Installing someone elses UDF
Hi, I am a VBA newbie and want to know how I go about installing a UDF that someone has sent me the code for? Is there an on-line idiot proof tutorial/explaination for this? Is it complicated? Dave ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Installing someone elses UDF
in a workbook, go to the VBE (Alt+F11)
do Insert=Module from the menu Paste the UDF in the module. Do Alt+F11 to return to excel. Now you should be able to go to a cell and do =Myfunction(arg1, arg2) as an example. -- Regards, Tom Ogilvy "DavidObeid" wrote in message ... Hi, I am a VBA newbie and want to know how I go about installing a UDF that someone has sent me the code for? Is there an on-line idiot proof tutorial/explaination for this? Is it complicated? Dave ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Installing someone elses UDF
Open your desired workbook
Press Alt + F11 (opens VBA) Find your book in project explorer (on the right of the screen) It should be something like VBAProject(YourBookName.xls) Right click on it and choose Insert - Module A code window should appear (if not find Module1 under your project and double click it) Paste your code into the window. Close VBA Dan E "DavidObeid" wrote in message ... Hi, I am a VBA newbie and want to know how I go about installing a UDF that someone has sent me the code for? Is there an on-line idiot proof tutorial/explaination for this? Is it complicated? Dave ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Installing someone elses UDF
Thanks gents. One more question. Is there a way to make te UDF available in other workbooks? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Installing someone elses UDF
Save the workbook containing the code as an addin (.xla). Then you can load
it under Tools=Addins, use the browse button to find it. -- Regards, Tom Ogilvy DavidObeid wrote in message ... Thanks gents. One more question. Is there a way to make te UDF available in other workbooks? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Installing someone elses UDF
Thanks Tom, You are a legend. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when installing Add-ins | Excel Discussion (Misc queries) | |||
Installing MS Office | New Users to Excel | |||
self-installing add-in? | Excel Programming | |||
self-installing add-in? | Excel Programming | |||
self installing macro | Excel Programming |