khalid79m
11-28-2008, 06:26 AM
'Unique TT NamedRanges
With Range("TT")
.Locked = False
.Validation.Add Type:=xlValidateDecimal, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="00:01", Formula2:="99:99"
.Validation.IgnoreBlank = False
.Validation.ErrorTitle = "Time Error"
.Validation.ErrorMessage = "Please Enter Minutes & Seconds in this format 23:59"
.Validation.ShowError = True
End With
What I want to achieve is with range "TT" I want the user to be only able to put in minutes and seconds in the format 23:59 (twenty three minutes and 59 seconds) ... i cant get it to do that , the nearest ive got is with a decimal point rather than : , but the problem with decimal it accepts whole numbers :) so someone could potentionally type in 23 and it would accept it and display it as 23 rather than 23:00 (23 minutes 0 seconds)
can and one help ....????
With Range("TT")
.Locked = False
.Validation.Add Type:=xlValidateDecimal, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="00:01", Formula2:="99:99"
.Validation.IgnoreBlank = False
.Validation.ErrorTitle = "Time Error"
.Validation.ErrorMessage = "Please Enter Minutes & Seconds in this format 23:59"
.Validation.ShowError = True
End With
What I want to achieve is with range "TT" I want the user to be only able to put in minutes and seconds in the format 23:59 (twenty three minutes and 59 seconds) ... i cant get it to do that , the nearest ive got is with a decimal point rather than : , but the problem with decimal it accepts whole numbers :) so someone could potentionally type in 23 and it would accept it and display it as 23 rather than 23:00 (23 minutes 0 seconds)
can and one help ....????