/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

0 vote114 views1 answer
Excel vba existence of a file
VBA
0 vote122 views1 answer
Dynamic array vba
VBA
12 votes167 views1 answer
Excel vba write string to text file
VBA
0 vote117 views1 answer
How to format a textbox as date vb net
VBA
2 votes128 views1 answer
Excel vba check if string entirely numeric
VBA
1 vote117 views2 answers
Vba remove first 2 characters from string
VBA
0 vote127 views1 answer
Add text to combobox drop down vb
VBA
0 vote130 views1 answer
VB Error Code BC30201
VBA
0 vote119 views1 answer
Excel vba hide columns
VBA
0 vote126 views1 answer
Remove series name from legendvbnet
VBA