etc_cu2

  1. 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...
  2. 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...
  3. 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'?

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top