/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 vote247 views1 answer
Enable macros on opening workbook vba
VBA
0 vote238 views1 answer
Reset border color textbox vba
VBA
0 vote258 views1 answer
Vba static variable
VBA
1 vote269 views1 answer
Excel vba get column number from column name
VBA
0 vote254 views1 answer
Excel vba copy range with filter
VBA
0 vote250 views1 answer
Vba get relative cell address
VBA
0 vote246 views1 answer
Excel vba formatconditions positive
VBA
0 vote185 views1 answer
How to make a if statement with vbs
VBA
1 vote245 views1 answer
Extract the second word in a text in excel
VBA
0 vote247 views1 answer
How to set location and size of new from vb
VBA