add time in textbox

[chris85]

hi,

I try find out in textbox properties the way of entering time into a textbox as 12.30 but I did not find how to!
I would like to have a dot between figures, e.g to add 12 then jump over dot and add 30 and in the textbox to show 12.30.
thanks for your help!

chris

[royUK]

Not possible in Excel's TextBoxes unfortunately

[chris85]

Roy, thank you!
chris

[royUK]

I use ComboBoxes sometimes - one each for Hours, Minutes & Seconds

[jwright650]

Could do as Roy said he's done in the past, and then concantenate the hours and mins into one cell together separated by the single dot....to get 12.30...see attached

[chris85]

Thx, I try to use comboBoxes but it takes much more time n being in a hurry when i add the time...
that's it!
chris

[chris85]

hi jwright, thank you, it's a good ideea, i'll keep in mind!
but I need to add the time into a user form.

thanks!
chris

[royUK]

See this example

[chris85]

sorry, I do not find the address

[jwright650]

sorry, I do not find the address

Roy, the link is broken.