Split textbox string to 3 textboxes

[Jaye7]

I would like a script that splits the following textbox1. value into 3 parts and puts each value in a textbox.

textbox1.value= 1:26:35

splits it as follows

textbox2.value = 1
textbox3.value = 26
textbox4.value = 35

the value could change though to

textbox1.value = 14:26:35 but will only ever have 2 values between each lot of : so it would never be 143:26:35 etc...

 

[Marcelo Branco]

Maybe something like

TextBox1.Value = "14:26:35"
TextBox2.Value = Left(TextBox1.Value, InStr(1, TextBox1.Value, ":") - 1)
TextBox3.Value = Mid(TextBox1.Value, InStr(1, TextBox1.Value, ":") + 1, 2)
TextBox4.Value = Right(TextBox1.Value, 2)

M.

 

[Jaye7]

Perfect, thanks very much Marcelo.

 

[Marcelo Branco]

Perfect, thanks very much Marcelo.

You are welcome and tks for the feedback

M.