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'?

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...