Hi
I am currently using the change event on a sheet that works when a user manually types on the sheet vba then marks the sheet to print, but I also need vba code to check the same sheet for updated formula results which show text not numbers and mark the sheet to print as well. My understanding is I may also need to use the calculate event. Is there a way to do this?
Thank you, Laurie
Just like you've put vba code in the Worksheet_Change() sub, you can put any vba-code in the Woksheet_Calculate() sub.
Go to the Worksheet_Change() sub and select Calculate in the right selection list on top of the editor pane.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks