Results 1 to 3 of 3
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Add New items to Autocalculate Menu (97+)

    The AutoCalculate menu occurs when you right click near the statusbar. You can select from various items to display to the right of the status bar a statistic of the selected range (the default is "SUM")

    The AutoCalc menu has the following items and ids:
    None(ID=2012), Average(ID=2013), Count(ID=2014), Count Nums(ID=2015), Max(ID=2016), Min(ID=2017), Sum(ID=2018)

    A couple questions:
    1) are there other of the "standard" stat functions that can be added (Variance or standard deviation, eg). My speculation is "no" since there are no "similar ID"s above this range or below (1989-2011 are "missing", 2019 - 2029 are "Autofill menu items"). If my speculation is incorrect, what are the IDs to add them to the menu to use this functionality?

    2) Is there any way to add your own "User-defined function" to this menu to give it the "same functionality" (selecting it from the autocalc menu would do the function and put the "result" to the right of the statusbar")? If so how would the function be written?

    I assume in either case that it would be added to the right-click menu as one can add other items to right click menus (ie like demonstrated many times on these pages - eg <post#=412671>post 412671</post#> for a recent one). The question is what ID to use to add a "builtin" or how to create a user defined function with the same functionality.

    The problem is not the ability to edit this menu (that seems straightforward) it is adding an item that has the functionality to add info to the right of the status bar.

    My "gut feeling" leans toward the item not being accessible to us that readily, or perhaps it is just something "simple" that I have never seen before.

    Thanks,
    Steve

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add New items to Autocalculate Menu (97+)

    Steve,

    a) I can't see any other statistical functions in the ID range 1 to 5400, so I think you'll have to roll your own.

    [img]/forums/images/smilies/cool.gif[/img] I don't think any of the boxes at the right hand side of the status bar are exposed to the vba object model. That said, it may still be possible with API calls as I have seen (in the dim and distant past) an add-in written to widen the drop-down name list box on the formula bar.

    HTH
    Brooke

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Add New items to Autocalculate Menu (97+)

    Thanks,
    You seem to have come pretty much to the same conclusion as I did.

    I know nothing (other than using functions others have created <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) about API calls so will not really investigate this.

    Steve

Posting Permissions

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