J-Walk & Associates, Inc.

A Very Polite Add-In

In Excel 2007, it's no longer possible to directly change a point a chart. In previous versions, you could drag a chart point to change the underlying value. Microsoft has come to the rescue: Excel Add-In for Manipulating Points on Charts.

I tried it, and it works. The VB Project is even unprotected, so you can view the code and maybe learn a thing or two.

One thing that struck me is the use of of the word please. I don't think I've ever seen an Excel dialog box that uses the word please. Nothing wrong with it, but it just seems kind of odd.

- Reader Comments -

Following are comments in response to this item.
The most recent comment is at the bottom.

1. By Ken Puls. Comment posted 02 November, 2009 7:36pm

   Weird... all the add-ins I build at work say "please" in them. (Please select a cell, please confirm, please hand over your Canadian Tire Money, etc...)
   
   Maybe it's a Canadian thing and there just aren't that many Canadian-built Excel Add-ins?
2. By Rob. Comment posted 03 November, 2009 12:07am

   Those controls are all a bit squashed in, aren't they?
   
   Personally, I favour using up as little screen area as possible with my dialogs, but this seems a little extreme. They've even done non-standard stuff with the frame caption in order to achieve it.
   
   No hot-keys, I notice.
3. By Yogesh Gupta. Comment posted 03 November, 2009 4:44am

   Is it a Indication that MS is learning to be polite...
   
   Being polite with the customers is what pays in long run... May be it is the beging or it is just a mistake and this addin got released without notice....
   
   Their people must be busy with Office 2010...
4. By Excel Training. Comment posted 03 November, 2009 1:47pm

   I've been using 2007 since it came out and never noticed this feature was missing. Thanks for the tip and suggestion to look at the VBA.
   Billy Gee
5. By Stray__Cat. Comment posted 06 November, 2009 5:25pm

   This is a key tool for budget applications! Think of the possibilities!
6. By Gordon. Comment posted 11 November, 2009 1:58am

   I'm curious about the VBA used for this but don't have 2007 and the VBA doesn't seem to survive the conversion process. Could someone paste it somewhere?