Hi Guys, me again!
Right im having a few troubles with some code im writing.
What im trying to acheive, is that a macro runs on the "Workbook_BeforeSave", checking that a few cells that HAVE to be filled in, are infact filled in... now i had a piece of code that checked the cells and fired up a MsgBox, but in order to check each and every specified cell, it had to run an "If"
on each of them, end up with me having to click ok to several different message boxes.
this is the code that did that:
Now as stated above, i couldnt have several MsgBoxes apearing everytime, so i figured, one script, to check all cells, one at a time, in a loop or something, filling in the background red as it found a field that wasnt filled, that was meant to be, then throwing up a MsgBox at the end IF there are fields un-filled. if all fields are filled, then obviously, carry on saving...
This is what i have been playing with, which just doesnt work at all, but should give you a flavour of what im looking for:
If anyone can help me figure this out it would be great! im just trying to "Idiot Proof" purchase orders and my work
Bookmarks