Function-excelvba

[grkchakri]

Hi All


My Query is about a function in excel.

If i want to write a function in excel , i know it should be written on the module level. But i am unable to understand how that function
should work on a sheet. How do we link that function to a range in a sheet.

For example i write a function something like below. How should this be linked to a sheet so that whenver i enter numbers from a1:a10 and b1:b10
the result should be showing in the respective columns C. Considering everything is on sheet1.

What will be the event on sheet1 where i need to link this function

MANY THANX IN ADVANCE

Please Login or Register  to view this content.

[MarvinP]

Hi grkcharkri,

You have created a User Defined Function or UDF. Because you have put it in a MODULE it will work on any worksheet. See the example that uses your function.

read more at http://www.decisionmodels.com/calcsecretsj.htm or search the net.