Thanks Ashish. I thought it might be something like that but I had actually pinged John Walkenbach about it and he said he's able to see his functions in that pop-up box. In retrospect, I may not have been clear about what I was asking and he was talking about something else. Again, thanks for the info.
On Apr 19, 7:07 am, Ashish Jain <[email protected]> wrote: > 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?- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
