run a macro when a control reaches certain value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form to update records. For each record that has been processed I
increase the value of a counter. After the counter reaches 100 I want to run
a Macro that displays a Batch ID and resets the counter to start over. Is
there some way I can run the Macro based on the value of the counter?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

variable in a chart macro 1
Run Macro If Cell have "x" value 0
condition in a macro 5
copying columns 3
Static Variable 4
Find and Replace using a Loop won't stop 2
Can't make loop macro work - help? 1
Macro, how to set a cell value to zero 1

Back
Top