VBA to Validate Data

[PosieQ]

Hello,

I am a true beginner to VBA and would like some help in creating a macro that is triggered when the user goes to save the document. The document contains a check box and, if checked, cell B28 will show TRUE. If the check box is checked, the user is expected to enter additional information in B30. I would like to create a macro with the following conditions so that a message appears when the user tries to save the document:

If B28 is TRUE and B30 is blank, show the message "Please enter a number in B30".

Please let me know if I have not provided enough information. Thank you in advance!

 

[PosieQ]

This worked. Thank you, and thanks for clarifying about having to use a user form for those command buttons!

 

[MrIfOnly]

You're welcome.

CJ