User Profile

Collapse

Profile Sidebar

Collapse
royale47
royale47
Last Activity: Sep 29 '11, 05:06 PM
Joined: Sep 28 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • royale47
    replied to VBA noob Trouble with DateDiff in VBA application
    in Visual Basic
    Thank you looking at your code I realized I needed to read the values for configstartdate and configenddate from the worksheet into a local variable before the operation, it works now.

    probabaly basic stuff but just getting into VBA.
    See more | Go to post

      Leave a comment:

    • royale47
      started a topic VBA noob Trouble with DateDiff in VBA application
      in Visual Basic

      VBA noob Trouble with DateDiff in VBA application

      the following is not returning a negative number even when the start date is later than the end date. Some help would be very appreciated! thank you -


      Private Sub CommandButton1_ Click()
      If DateDiff("d", ConfigStartDate , ConfigEndDate) >= 0 Then
      Range("ConfigEn dDate").Value = Calendar1.Value
      UserForm3.Hide
      Else
      MsgBox "End...
      See more | Go to post
      No activity results to display
      Show More
      Working...