sujittalukde
06-06-2007, 11:13 PM
I want to make a wb wherein want that some sort of validation check should be there. AS this file will be used by branches & will be send back to HO for consolidation purpose, I want that all the required cells of all sheets must be filled in 7 users, before sending the file, should validate the file to check whether all the requisities are filled in. To make this simple, I am narrating the requirements only. the code shuold be designed in a simple manner so that I can later on modify it. Note that the wb will be password protected. My requirement is as follows:
1. the code will be assigned to a button on sheet1 & when the button will be clicked it will check all the sheets, all the mentioned cells (ie cells mentioned in the code to check) & if found those cells as blank, make those cells background color as "red" and will display a printable list showing the list of red coloured cells in the following format-
Ref Sheet1 A3
Ref Sheet1 A4
Ref sheet3 B5
& so on.
2. As the validation requirement is dynamic for me, I'm giving a simple principle to make the code.
For Sheet1, A1 to A34 are mandatory cells,
for sheet2, B5 is mandatory
For Sheet3, B2 to C10 and E20 to G25
Hope this will clear the problem. In case furhter clarification is needed, let me know. I'll try to clear
1. the code will be assigned to a button on sheet1 & when the button will be clicked it will check all the sheets, all the mentioned cells (ie cells mentioned in the code to check) & if found those cells as blank, make those cells background color as "red" and will display a printable list showing the list of red coloured cells in the following format-
Ref Sheet1 A3
Ref Sheet1 A4
Ref sheet3 B5
& so on.
2. As the validation requirement is dynamic for me, I'm giving a simple principle to make the code.
For Sheet1, A1 to A34 are mandatory cells,
for sheet2, B5 is mandatory
For Sheet3, B2 to C10 and E20 to G25
Hope this will clear the problem. In case furhter clarification is needed, let me know. I'll try to clear