/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 vote167 views1 answer
Remove series name from legendvbnet
VBA
5 votes105 views1 answer
Vlookup vba
VBA
0 vote150 views1 answer
Excel text to columns line break
VBA
0 vote212 views1 answer
Find control with name vb
VBA
0 vote183 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote160 views1 answer
Get current url vb.net
VBA
5 votes184 views1 answer
Excel vba how to unit test vba code
VBA
31 votes306 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote174 views1 answer
Add text to Shape VBA
VBA
3 votes170 views1 answer
Vba http request json
VBA