MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

UDF Works only in One Sheet, Not in Other Sheets

  Asked By: John    Date: Sep 16    Category: MS Office    Views: 2623

I used my "tax" function in one sheet over and over again, but when I
tried to use the function to other sheets, the "tax" function
displays "#VALUE!" error.

What could be wrong with this one guys? Is there something else I need
to know about creating User Defined Functions? Or is it in my code



2 Answers Found

Answer #1    Answered By: Horace Hernandez     Answered On: Sep 16

You probably have the function  in the worksheet code. You need to add a
module and put the function in that. To add a module right click the workbook
in the project explorer window in the VB editor and select add module.

Functions in sheets  are only available to the sheet  they belong to.

Answer #2    Answered By: Hasad Yilmaz     Answered On: Sep 16

Whenever I create a user-defined function  in
Excel, I never thought on what you have advised me. I still have a lot to learn
though and I'm glad guys like you could be easily reached for help. I'm just new
to this Excel VBA thing and I'm also glad that my programming background helped
me learn quite conveniently..

Didn't find what you were looking for? Find more on UDF Works only in One Sheet, Not in Other Sheets Or get search suggestion and latest updates.