Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date format
I have a cell where people type in a date. The format is "mm/dd/yyyy" (e.g.
11/18/2005). I want to write a "If" statement to check whether the user types in a date in that cell. If they leave it blank or type anything else, I want to have a message box comes up. So this is what I have, and it's not working. If ActiveSheet.Range("B8").NumberFormat < "m/d/yyyy" Then MsgBox "Please enter a date in cell B8.", , "Warning!" Please help. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date format
How about
With Activesheet.Range("B8") If .Value < "" Then If Not IsDate(.Value) Then MsgBox "Please enter a date in cell B8.", , "Warning!" EndIf Else MsgBox "Please enter a date in cell B8.", , "Warning!" End If End With -- HTH RP (remove nothere from the email address if mailing direct) "AccessHelp" wrote in message ... I have a cell where people type in a date. The format is "mm/dd/yyyy" (e.g. 11/18/2005). I want to write a "If" statement to check whether the user types in a date in that cell. If they leave it blank or type anything else, I want to have a message box comes up. So this is what I have, and it's not working. If ActiveSheet.Range("B8").NumberFormat < "m/d/yyyy" Then MsgBox "Please enter a date in cell B8.", , "Warning!" Please help. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
date format
Thanks Bob. Your code works, but that code would not go along with mine.
That code is just a small piece of mine. I have to use "If" statements. Basically, my whole code would test that cell first for date. Then if it is true, it will go on to another "If" statement and so on. Can you help me with "IF"? Thanks. "Bob Phillips" wrote: How about With Activesheet.Range("B8") If .Value < "" Then If Not IsDate(.Value) Then MsgBox "Please enter a date in cell B8.", , "Warning!" EndIf Else MsgBox "Please enter a date in cell B8.", , "Warning!" End If End With -- HTH RP (remove nothere from the email address if mailing direct) "AccessHelp" wrote in message ... I have a cell where people type in a date. The format is "mm/dd/yyyy" (e.g. 11/18/2005). I want to write a "If" statement to check whether the user types in a date in that cell. If they leave it blank or type anything else, I want to have a message box comes up. So this is what I have, and it's not working. If ActiveSheet.Range("B8").NumberFormat < "m/d/yyyy" Then MsgBox "Please enter a date in cell B8.", , "Warning!" Please help. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
date format
Perhaps just try
If IsDate(Range("B8").Value Then ' your code -- HTH RP (remove nothere from the email address if mailing direct) "AccessHelp" wrote in message ... Thanks Bob. Your code works, but that code would not go along with mine. That code is just a small piece of mine. I have to use "If" statements. Basically, my whole code would test that cell first for date. Then if it is true, it will go on to another "If" statement and so on. Can you help me with "IF"? Thanks. "Bob Phillips" wrote: How about With Activesheet.Range("B8") If .Value < "" Then If Not IsDate(.Value) Then MsgBox "Please enter a date in cell B8.", , "Warning!" EndIf Else MsgBox "Please enter a date in cell B8.", , "Warning!" End If End With -- HTH RP (remove nothere from the email address if mailing direct) "AccessHelp" wrote in message ... I have a cell where people type in a date. The format is "mm/dd/yyyy" (e.g. 11/18/2005). I want to write a "If" statement to check whether the user types in a date in that cell. If they leave it blank or type anything else, I want to have a message box comes up. So this is what I have, and it's not working. If ActiveSheet.Range("B8").NumberFormat < "m/d/yyyy" Then MsgBox "Please enter a date in cell B8.", , "Warning!" Please help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming |