/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

22 votes574 views1 answer
Xl vba check for folder
VBA
0 vote376 views1 answer
Make your computer talk vbscript
VBA
5 votes403 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote334 views1 answer
Dynamically change drop down list visual basic
VBA
1 vote364 views1 answer
What does vbs stand for
VBA
1 vote358 views1 answer
Vb.net get name by Selection Changed
VBA
5 votes382 views1 answer
Vba low word from Long Integer
VBA
1 vote300 views1 answer
Vba Remove Case Sensitivity
VBA
18 votes512 views3 answers
Excel-vba make integer
VBA
0 vote378 views2 answers
Open url from vba
VBA