/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 vote293 views1 answer
Vba check 32 or 64 bit
VBA
1 vote287 views1 answer
Excel vba autofit
VBA
2 votes278 views1 answer
Vba array contains
VBA
1 vote302 views1 answer
Vb.net get name by Selection Changed
VBA
-1 vote265 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
1 vote301 views1 answer
Random number generator vb.net
VBA
0 vote302 views1 answer
Vbnet cycle through charaters in string
VBA
3 votes303 views1 answer
Vba make long from two words
VBA
3 votes294 views1 answer
Excel vba change format of cell
VBA
0 vote303 views1 answer
Vba remove last vbcrlf
VBA