View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson[_4_] Greg Wilson[_4_] is offline
external usenet poster
 
Posts: 218
Default what is this object called? - right hand corner of statusbar

The following will call the menu if it's of any use:
Application.CommandBars(49).ShowPopup

Regards,
Greg

-----Original Message-----
In the bottom right hand corner of the status bar (right

click). A user has
the ability to either Average, Count, Count Nums, Max,

Min or Sum the
contents of the highlighted range. I want to be able to

call that procedure
using an OnKey Method to copy that value to the

clipboard. Then the user
could paste that value elsewhere in excel.


.