Hello
I just disceovered that the user defined function of excel is written in VBA. I have got this excel file with a number of user defined functions. is it possible for me to obtain the code of those functions
Printable View
Hello
I just disceovered that the user defined function of excel is written in VBA. I have got this excel file with a number of user defined functions. is it possible for me to obtain the code of those functions
In your excel workbook you can access the VBA Editor by pressing Atl+F11.
Look in the modules, they should be in there.
thanks dude
i found them, they are listed as a module
i can see a bunch of sheets(microsoft excel objects) which correspond(namewise) to the worksheets.
could they possibly contain some user defiined functions. when i click on them they seem to be empty?
when i change the value in one of the cells, these cells being referenced by a UDF, the UDF loses its value and instead comes up with #NAME?
even when i change the value of the first cell back to what it was, the #NAME? stays put.
why is this?