Hi there, I'm very green to VBA and am trying to write a code to run multiple data validations in tables, each with their own hard stop error message.
The spreadsheet is a data entry spreadsheet and here are the rules:
1) data entered in cell must be numeric - Shading cell with light red color and Popup with error returning you to cell to fix it
2) if data is entered in any of cells C7:H7, then cell B7 must have a value as well - Popup with text box asking what should be in B7 and it auto populating B7
3) data in cell D7 must not exceed value in C7 - Popup with error returning you to cell D7 to fix
4) sum of data in cells F7:G7 cannot exceed value in E7 - Popup with error returning you to last cell data was entered in
These rules would run in tables until the end user has no more data to enter.
I cannot tell you how much time I've tried drafting individual codes and search the error messages when they don't work but am hoping someone on here can help.
Thank you much!!!
The spreadsheet is a data entry spreadsheet and here are the rules:
1) data entered in cell must be numeric - Shading cell with light red color and Popup with error returning you to cell to fix it
2) if data is entered in any of cells C7:H7, then cell B7 must have a value as well - Popup with text box asking what should be in B7 and it auto populating B7
3) data in cell D7 must not exceed value in C7 - Popup with error returning you to cell D7 to fix
4) sum of data in cells F7:G7 cannot exceed value in E7 - Popup with error returning you to last cell data was entered in
These rules would run in tables until the end user has no more data to enter.
I cannot tell you how much time I've tried drafting individual codes and search the error messages when they don't work but am hoping someone on here can help.
Thank you much!!!