Hi Jake, He is right and I won't say that it's absolutely impossible. Using VBA only it's pretty not possible. By Overriding the the function's class in a specific dll, you can do so. But for that you should be aware of the dll name, class name and the knowledge of API Prog. and building+deploying dll . I know all this except the DLL and Class name, so won't be able to help much.
Regards Ashish Jain www.excelitems.com Developer of OpenXL -------------------------------------------------------------------- On Apr 24, 9:43 pm, Jake <[email protected]> wrote: > 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] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
