/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

1 vote330 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
5 votes332 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote346 views1 answer
Excel vba set cell value to empty
VBA
1 vote304 views1 answer
How to do error handling in access vba
VBA
4 votes318 views2 answers
Vba create folder if not exist
VBA
1 vote308 views1 answer
Excel vba last row of range
VBA
0 vote323 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote332 views1 answer
Excel vba clear filter
VBA
0 vote298 views1 answer
Vba apostrophe chr
VBA
1 vote305 views1 answer
Excel vba make cell visible
VBA