Hi Jake, No, there is no way to get your function listed in that box and the reason is that you're using code behind(VBA). This restricts your function to be used from a workbook only where your function code is placed. Maximumly you can add it to a personal workbook or in an add- in but still that will be code behind. The built-in functions are defined in functions assembly of excel from where it fetches that information.
For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com ------------------------------------------------------------------------ Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Excel and VBA Trainer Author -> www.excelitems.com +91-9999-40-48-43 ------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------- On Apr 17, 11:08 pm, Jake <[email protected]> wrote: > I just finished writing my first function. It works fine and shows up > in the User Defined section of the Insert Function dialog box. > However, when I type it into a cell, it doesn't show up in the little > auto complete pop-up window. Is there any way to get my function to > appear with the built-in functions in this pop-up box? --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
