/VBA/How to convert weeks to days into textbox with VB site:stackoverflow.com

How to convert weeks to days into textbox with VB site:stackoverflow.com

'TextBox1 is where the user inputs the number of minutes
Private Sub TextBox1_TextChanged(sender As Object, e As EventArgs) Handles TextBox1.TextChanged
    Dim d = TimeSpan.FromMinutes(TextBox1.Text) 'creates a TimeSpan based on user input, this is also a variable creation


    TextBox5.Text = d.ToString("dd\:hh\:mm") 'you can format it with a custom format


    'Or you can access the elements of the TimeSpan like so

    TextBox2.Text = d.Days
    TextBox3.Text = d.Hours
    TextBox4.Text = d.Minutes
End Sub

Source: stackoverflow.com

Similar codes

31 votes395 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote306 views1 answer
Vba registry settings
VBA
0 vote279 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote282 views1 answer
Excel vba address not absolute
VBA
0 vote289 views1 answer
Freeze panes vba
VBA
1 vote316 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote311 views1 answer
Vba extract filename from path
VBA
0 vote285 views1 answer
Dynamic array vba
VBA
0 vote272 views1 answer
Excel vba disable mouse click
VBA
5 votes281 views1 answer
Excel vba how to unit test vba code
VBA