Daf-the-Bear
New Member
- Joined
- Oct 3, 2011
- Messages
- 2
Hi folks,
I'm new to this forum and a relative novice with vba so I hope I'm articulating the problem adequately here... It seems like it should be a simple thing but I've spent hours at this stage trying and failing...
For each row on the worksheet, columns G and H are populated with either "Yes" or "No". At the moment, if either cell contains "No", the whole row's font is red and whichever cell it is (or both) is unlocked for editing. When both cells contain "Yes", font colour is xlAutomatic and cells are locked for editing. This is all fine.
The problem: I want to edit the "No" cells as required, changing to "Yes" from a data validation list and then run a macro to update the entire sheet (when all changes have been made) to format colour of rows and lock "Yes" cells for editing.
I've tried dozens of different approaches to this, If statements, Case statements etc. but as I say, I' a bit of a novice on vba. Any help would be much appreciated...
I'm new to this forum and a relative novice with vba so I hope I'm articulating the problem adequately here... It seems like it should be a simple thing but I've spent hours at this stage trying and failing...
For each row on the worksheet, columns G and H are populated with either "Yes" or "No". At the moment, if either cell contains "No", the whole row's font is red and whichever cell it is (or both) is unlocked for editing. When both cells contain "Yes", font colour is xlAutomatic and cells are locked for editing. This is all fine.
The problem: I want to edit the "No" cells as required, changing to "Yes" from a data validation list and then run a macro to update the entire sheet (when all changes have been made) to format colour of rows and lock "Yes" cells for editing.
I've tried dozens of different approaches to this, If statements, Case statements etc. but as I say, I' a bit of a novice on vba. Any help would be much appreciated...
