View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Rich is offline
external usenet poster
 
Posts: 298
Default Is there a "ChangeCell" event?

I have a pulldown list of values. I need to run a macro whenever the value
of the cell with the pulldown changes.

For example, If the cell is changed from "Master" to "Balance", I need a
macro to run to unhide certain sheets and hide others. The macro (vba code)
is not the problem - it's just having excel execute the code if the cell
value changes.

Any help in pointing me in the right direction is appreciated!!