/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

3 votes204 views2 answers
Vba active workbook path
VBA
0 vote192 views1 answer
Vb.net change cursor to wait
VBA
0 vote221 views1 answer
Excel vba add reference programmatically
VBA
1 vote202 views1 answer
VBA Loop through recordset
VBA
3 votes181 views1 answer
Excel vba last row in range
VBA
4 votes202 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
3 votes201 views1 answer
Vba folderexists
VBA
0 vote193 views1 answer
Vbnet check if string is only numbers
VBA
0 vote228 views1 answer
Vba registry settings
VBA
8 votes224 views1 answer
Excel vba determine number of elements in a 2D array
VBA