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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top