vba lock text in a textbox

[Noz2k]

Is it possible to input some text into a textbox and prevent the user from deleting it, but still allow the user to input text of their own.

For instance, what I want to do is have a text box which asks the amount of hours lost.

I want this to be shown like 53 hrs 25 mins.

So ideally I would like the hrs and mins to already be in the textbox, and to limit the user to only input number values. I can do all this, but I don't know how to prevent the user from deleting the "hrs" or "mins" from the text.

Any ideas?

 

[MickG]

Perhaps something like this:-

Private Sub TextBox1_LostFocus()
Dim txt As String
txt = "    hh :    mm  "
    If Not Len(TextBox1) > Len(txt) Then
        TextBox1.Text = txt
    End If
End Sub

 

[stefankemp]

Would it be an option to use two separate text boxes and two lables instead?

 

[Noz2k]

Yes Stefan, that's what I have now done.

Thanks MickG, I will make a note of that for when I need it in the future.