I have a work schedule that I have created and I would like to place some code in there that verifies the entries are a proper time format and not text.
I have the basic part of the code done but I'm having some difficulty with it searching through the various cells. Unfortunately the cells are just one big list or it would be easy enough for my code to work. I started to create multiple ranges and I was going to create some for statements to cycle through but I figure there must be a simpler way. You will find my attached worksheet.
Any help would be appreciated. I've attached what I have so far.
EMAC 2014 Schedule vba times2.xlsm
Bookmarks