#1
|
|||
|
|||
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 Dim XI find X = "Error 2015". What am I doing wrong? Solved the problem: It should be: X = Application.Run("PERSONAL.XLSB!fTest2", 4) Last edited by coffent; 05-17-2020 at 07:08 PM. Reason: Solved the problem |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Function not available from personal.xlsb | slouw | Excel Programming | 1 | 04-04-2016 12:32 AM |
Error message opening xlsb file in Excel 2008 for Mac | Bryce | Excel | 1 | 07-27-2014 09:35 AM |
Visibility of macros in PERSONAL.XLSB | Dougiel | Excel | 0 | 05-24-2012 12:32 AM |
How to call an object of opened appointment? | NIBARIM | Outlook | 0 | 05-23-2012 07:06 AM |
Call Excel from Word | donlincolnmsof | Word | 0 | 10-14-2011 05:02 PM |