-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
etc_cu2
-
A
Userform Controls - Problem suspending textbox change routines
I have run into a problem with my userform control triggers. Consider the code below and this particular scenario. I have a userform, with two textboxes (cu2_start, cu2_end) in which the user may enter a time. Here is the control change code for 'cu2_start': Private Sub...- Ark68
- Thread
- code cu2_end end etc_cu2 mbevents
- Replies: 1
- Forum: Excel Questions
-
A
Adding 8 hours to a time.
In my userform, I enter 8:00 into textbox 'cu2_start'. This represents 8:00 AM. etc_cu2 = format(CDate(cu2_start.Value), "0.00000") This line converts the text time to a decimal time value ... in this case etc_cu2 = "0.33333" hj = etc_cu2 + 8 cu2_end.Value = format(hj, "hh:mm") I am...- Ark68
- Thread
- cu2_end etc_cu2 hours textbox time
- Replies: 2
- Forum: Excel Questions
-
A
Getting Decimal Equivalent of Textbox Time Entry
I'm a bit stumped ... when I enter "0:00" into textbox 'cu2_end' .... etc_cu2 = CDate(cu2_end.Value) Debug.Print etc_cu2 I am returned the correct value for 'etc_cu2' which is 12:00:00 AM. How can I get the decimal equivalent returned for 'cu2_end'?- Ark68
- Thread
- cu2_end decimal equivalent etc_cu2 returned
- Replies: 2
- Forum: Excel Questions
