Re: second event

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Although you should certainly do your best to ensure that the source data is
entered correctly, you probably shouldn't assume that it is.

You may want your program to pre-scan to make sure the source rows don't
have blank cells before beginning processing. Based on what your program
needs, you can pre-scan the entire region and abort if there are any blank
cells in any row. Or you might get away with pre-scanning row-by-row and
have your program skip any rows which have blank cells.

Additionally, consider using default values which you could fill in
programmatically as the user moves into a required cell.

"Curt" <Curt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0B08F7EF-B56A-419D-807E-40D254B4E195@xxxxxxxxxxxxxxxx
thinking you can have more than 1 event in work***.
If so is it possible to check for blank cells in row when user hits
enter,down arrow or in any way trys to move to next row. The area covered
is
columns B:K. want to keep user in this row till all cells have entry. Do
not
need to clear contents only require no blanks in row. This is a safety
move
for program.
The help from this group is wonderful for those of us learning
Thanks Much


.

Quantcast