How to call a function in VBAProject(PERSONAL.XLSB)?

[coffent]

I have a simple test function fTest2 in VBAProject(PERSONAL.XLSB). I can run it from a spreadsheet by inserting "=PERSONAL.XLSB!fTest2(4)" into a cell. However if I try to do the same thing in VBA using

Please Login or Register  to view this content.

I find X = "Error 2015".

What am I doing wrong?

[6StringJazzer]

The syntax to call a function with arguments would be

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[coffent]

Worked like a charm! Thanks very much!

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

[coffent]

I've now done so. I looked for a "solved" choice before and didn't find it. Would it be helpful to display it as a main menu choice alongside Thread Tools, rather than as a drop-down beneath it?

Thanks again for the help.

[6StringJazzer]

I've now done so. I looked for a "solved" choice before and didn't find it. Would it be helpful to display it as a main menu choice alongside Thread Tools, rather than as a drop-down beneath it?

Thanks again for the help.

I'll pass that along. However, it only gets clicked once per thread. Our technical team has very long lead times for feature updates, but I'll see if I can get it in the queue.