Title:
Excel VBA - Macro Runs When Worksheet Changed
Video:
Description:blog.contextures.com Show a message in your Excel workbook by using a macro. Click OK to close message. The message will only appear if a specific cell has a value that is listed in the macro code. In this example, the message appears for customers in Canada. If customer is in USA, message will not appear. Then, add code to check which cell was changed, and only run the macro if the customer name was changed. This will prevent the macro from running when other cells are changed.
Published:
12/Oct/2010
Excel VBA - Macro Runs When Worksheet Changed
Video:
Description:blog.contextures.com Show a message in your Excel workbook by using a macro. Click OK to close message. The message will only appear if a specific cell has a value that is listed in the macro code. In this example, the message appears for customers in Canada. If customer is in USA, message will not appear. Then, add code to check which cell was changed, and only run the macro if the customer name was changed. This will prevent the macro from running when other cells are changed.
Published:
12/Oct/2010
No comments:
Post a Comment