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")

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.

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.