Time in Userform -> textbox

[dk-iceman]

Hi there

I have a userform that have a textbox, where I want to write the time format "TT:MM" . I know that a textbox is "dumb", but can It be made ?
then after the time tranfer it to a sheet called "data"

Please help

The Iceman

[mudraker]

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