Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Mon, 22 Sep 2003, zantor wrote:
You will have to use the 'IsDate' funcion: If IsDate(TextBox1) = False Then MsgBox "Not a valid date." Else MsgBox "Valid date" End If Thank you. I was not aware of Isdate. I will try this tomorrow at work, and hope that it exists in Excel 97. Don <donwiss at panix.com. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TextBox will not clear date??????????? | Excel Discussion (Misc queries) | |||
Textbox date formatting | Excel Discussion (Misc queries) | |||
Textbox to show date | Excel Discussion (Misc queries) | |||
Textbox date format. | Excel Discussion (Misc queries) | |||
Date format textbox | Excel Discussion (Misc queries) |