Time in a userform textbox

[Diving_Dan]

So I have scoured google looking for the answer but I can't find exactly what I'm looking for.

I've got a userform to input data onto a worksheet. One of the textboxes is called textTimeAuthorised and the time gets put into this textbox in 24hr format. what I am trying to achieve is after the hours have been put in it automatically adds the colon for the time rather than having to manually input it.

Is this easily possible?

Thanks in advance

Dan

 

[Anthony47]

Try using the following TextBox_Change macro:

Private Sub textTimeAuthorised_Change()
Dim cTxt As String
'
cTxt = Me.textTimeAuthorised.Text
If Len(cTxt) = 2 And Right(cTxt, 1) <> ":" Then
    Me.textTimeAuthorised = cTxt & ":"
End If
End Sub

Bye

 

[Diving_Dan]

Anthony that is perfect thank you