As you said a textbox is dumb, but you can add code so that it looks like it is smart.

You can use a TextBox1_Change macro to test what characters have been entered into the text box and make sure they follow a set format.

You can use a TextBox1_BeforeUpdate or TextBox1_AfterUpdate to check the entry is reconised as a time type entry


You can certainly have code that will add the details of the textbox to a sheet