/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

2 votes162 views1 answer
Excel vba check if key is in collection
VBA
0 vote174 views1 answer
VBA Sort RossetaCode
VBA
-1 vote190 views1 answer
How save excel through visual basic
VBA
0 vote158 views1 answer
Vba code to open a file with login rights
VBA
0 vote167 views1 answer
Excel vba unmerge sheet
VBA
0 vote162 views1 answer
How to use if condition in time vba
VBA
0 vote121 views1 answer
Vbide vbproject reference
VBA
0 vote198 views1 answer
Visual basic run command
VBA
0 vote152 views1 answer
Excel vba populate array with cell values
VBA
0 vote164 views1 answer
Excel vba delete folder
VBA