P
Patrick Simonds
I use the following code to enter data in a Userform, if the data already
exists on the spreadsheet. Everything works great, unless the time is 12:00
(using 24 hour time) then it displays on the Userform as 00:05, even though
it is displayed correctly on the spreadsheet.
'Places data in the userform text boxes if it exists on the spreadsheet
TextBox1.Text = rng(1, 47).Value
TextBox1.Text = Format(TextBox1.Text, "hh:mm")
TextBox2.Text = rng(1, 48).Value
TextBox2.Text = Format(TextBox2.Text, "hh:mm")
exists on the spreadsheet. Everything works great, unless the time is 12:00
(using 24 hour time) then it displays on the Userform as 00:05, even though
it is displayed correctly on the spreadsheet.
'Places data in the userform text boxes if it exists on the spreadsheet
TextBox1.Text = rng(1, 47).Value
TextBox1.Text = Format(TextBox1.Text, "hh:mm")
TextBox2.Text = rng(1, 48).Value
TextBox2.Text = Format(TextBox2.Text, "hh:mm")