/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 vote255 views1 answer
VBA Loop to range
VBA
13 votes514 views2 answers
Vba write text file
VBA
0 vote227 views1 answer
Send webhook vbscript
VBA
0 vote262 views1 answer
Vba sort multiple columns
VBA
1 vote239 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
-1 vote229 views1 answer
For i in range vba
VBA
2 votes243 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote239 views1 answer
Nested if else in vb.net
VBA
1 vote236 views1 answer
Excel vba saveas force overwrite
VBA
0 vote226 views1 answer
Afficher un message d'erreur vba
VBA