Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Marty Jackson   on Feb 21 In MS Office Category.

  
Question Answered By: Adalwine Fischer   on Feb 21

Worksheet change  is a good candidate, and aesthetically more "nice"
than the idea of an asynchronous routine fire-off.

However (i.e. no free lunch), the worksheet change event is a bit scatter-gun,
in that it fires with a change in any cell, whether you're interested in that
one or not. So you've then got to work out whether you should do the work on
the cell. I certainly use this approach in some instances, and ignoring
unwanted cells  isn't particularly cumbersome.

Share: 

 

This Question has 15 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Can a spreadsheet function change a cells appearance? Or get search suggestion and latest updates.


Tagged: