cu2_end

  1. A

    Overcome A 'BeforeUpdate' trigger when there is nothing to update?

    I've run into a problem that I hope someone can provide some advice on to resolve. I have a user form with two textboxes, cu2_start and cu2_end. Normally, these textboxes are filled as part of the userform's initialization procedure. Code associated with a 'BeforeUpdate' trigger of cu2_start...
  2. 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...
  3. 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...
  4. 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'?
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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