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

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

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

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

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

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