+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    05-17-2020
    Location
    Ann Arbor, MI
    MS-Off Ver
    16
    Posts
    5

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

    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?
    Last edited by 6StringJazzer; 05-17-2020 at 09:36 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,435

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

    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

  3. #3
    Registered User
    Join Date
    05-17-2020
    Location
    Ann Arbor, MI
    MS-Off Ver
    16
    Posts
    5

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

    Worked like a charm! Thanks very much!

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,435

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

    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.

  5. #5
    Registered User
    Join Date
    05-17-2020
    Location
    Ann Arbor, MI
    MS-Off Ver
    16
    Posts
    5

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

    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.

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,435

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

    Quote Originally Posted by coffent View Post
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-17-2019, 06:54 PM
  2. My computer crashed and now I can not establish a VBAProject (PERSONAL.XLSB)
    By Scshot in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-01-2018, 04:48 AM
  3. [SOLVED] Call a Macro in the Active Workbook from a Personal.xlsb procedure [RESOLVED]
    By Seke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2015, 06:17 AM
  4. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  5. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  6. How to save code under VBAProject(PERSONAL.XLSB) that applies to any workbook
    By bubai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2013, 08:01 AM
  7. Replies: 0
    Last Post: 05-10-2012, 09:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts