Trigger wrong time HELP

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

Guest

Want to use data entry in column (D) as trigger. Depending on data what I do.
There is other data that needs to be entered in this row befor the trigger
should fire. All I have done befor is have trigger fire when data was
entered. Is there a way to delay the action based on the data in column (D).
The action will be copying to another worksheet for later printing. Want to
keep this printing in excel if poss. Like excel print better than mail merge
to word.
Hope this is understandable.

Thanks to Any & All
 
Don't trigger on column D. Trigger on entry in any of the columns. In the
event code, check all the conditions for that row - if it meets all the
conditions, then take your action. If it doesn't, then don't do anything.
 
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

Data form not triggering Worksheet_Change event 3
HOW: Click Formula Hyperlink To Trigger Macro 1
Search for calculated duplicate using worksheet events - Possible? 1
Re : Excel FilterMode to Trigger WorkSheet_Calculate() 3
Using VBA to trigger a certain slide 0
Save As - triggers ListBox control 0
XL2007 (or 2003): Triggering SelectionChange event 1
RAND() Won't Trigger Worksheet_Change 5

Back
Top