Merging code - Validation and Formatting

I have Some Formatting that puts a ":" between 0000 to make a time 00:00

Please Login or Register  to view this content.

The above is the code.

I also want to apply some validation to the same range. However, the validation depends upon the Formatting. So I want the formatting to run first I have tried putting the validation in the code before the formatting but to no avail.

here is the validation and the formatting

Please Login or Register  to view this content.

The above validation wont work but the formatting does.

Alternatively,


I have just found that the validation wont work unless the information is manually entered into the cell, the result of a calculation slips by undetected. Is there anyway i can chage this.

Thanks in advance

Just found this out on the internet somewhere

"Note that Validation works only on direct user input. It does not work with data that is pasted in to a range, values that are the result of calculations, or cell modification by Visual Basic code."

Simon Green