Search This Blog

Excel VBA Calculating Days Between Two Dates

Calculating Days Between Date In Cell And Today 

            On userform ,days can be calculated until date in cell from today's date. Related codes :
.. TextBox15.Value = DateDiff("d", Date, Cells(ActiveCell.Row, 1).Value)
If Not IsDate(Cells(ActiveCell.Row, 1)) Then
TextBox15.Value = "Incorrect Value !"
End If
...




Please Share It :

5 comments:

  1. UnknownSeptember 21, 2016 at 5:21 AM

    Very nice Sir

    ReplyDelete
  2. Kadr LeynSeptember 21, 2016 at 9:18 AM

    I am glad you like it.

    ReplyDelete
  3. thienhayenOctober 27, 2016 at 1:26 AM

    I have learned a lot of knowledge on this website.
    Mr. Kadr Leyn, Thank you a lot.

    ReplyDelete
  4. AnonymousMay 17, 2024 at 7:56 AM

    merkez-ihayat.blogspot.com

    ReplyDelete
  5. AnonymousMay 17, 2024 at 7:56 AM

    arreglen la descarga porfavor / fix the download please

    ReplyDelete