View Single Post
  #1   Report Post  
jwwjd
 
Posts: n/a
Default Automate a macros when data in a cell changes (e.g.when using quer

Is there any way that a macro can be activated when the data of a specific
cell changes?

I assigned a macro to a "check box" button from the Tool Bar "Forms", and
used the "cell link" from the "check box" properties, so when the data
changes in the cell linked the "check box" is marked and the macro will
start. So far, the "check box" gets marked when data changes but the macro
doesn't start. The only way the macro starts is when I click in the "check
box".