Blog

VBA – IsDate Function

  • Post author:
  • Post category:VBA
  • Post comments:2 Comments
isdate

A Function, which returns a Boolean value whether or not the given input isdate.

Syntax

IsDate(expression)

Example

Add a button and add the following function.

Private Sub Constant_demo_Click()
   msgbox("Line 1 : " & IsDate("Nov 03, 1950"))
   msgbox("Line 2 : " & IsDate(#01/31/20#))
   msgbox("Line 3 : " & IsDate(#05/31/20 10:30 PM#))
End Sub

When you execute the above function, it produces the following output.

Line 1 : True
Line 2 : True
Line 3 : True

Previous Page:-Click Here

This Post Has 2 Comments

  2. tinjauan February 8, 2023

    Good article. I am going through a few of these issues as well..

Leave a Reply