Hello!
I have a spreadsheet with 64 tables set up on it. 4 tables in a row and 16 rows of tables. Each table has a different assortment of cells that have values and cells that do not have values. Every now and then we will need to add a value to a red cell in a pre-existing table or we will create a whole new row of tables. I was wondering if there is a VBA code that would automatically notify a user with a message box only when they try to add a value to an empty red cell that basically confirms if they'd like to enter a value in that empty cell? If there is code for this, would it apply to cells that end up having their values removed, which become empty red cells, or to tables that get added to the sheet in the future?
Thanks for any and all assistance!
dmissel23
I have a spreadsheet with 64 tables set up on it. 4 tables in a row and 16 rows of tables. Each table has a different assortment of cells that have values and cells that do not have values. Every now and then we will need to add a value to a red cell in a pre-existing table or we will create a whole new row of tables. I was wondering if there is a VBA code that would automatically notify a user with a message box only when they try to add a value to an empty red cell that basically confirms if they'd like to enter a value in that empty cell? If there is code for this, would it apply to cells that end up having their values removed, which become empty red cells, or to tables that get added to the sheet in the future?
Thanks for any and all assistance!
dmissel23