svendiamond
Well-known Member
- Joined
- Jun 13, 2014
- Messages
- 1,504
- Office Version
- 365
- Platform
- Windows
How can I use Select Case to determine whether a cell contains a date? For example, I am looping through the following cells:
Cookies
12/2/2015
Apple
Banana
123
Example
How can I accomplish this?
Cookies
12/2/2015
Apple
Banana
123
Example
Rich (BB code):
Select Case testCell.Value
Case Is = "Cookies", "Apple", "Banana"
MsgBox "this is a food"
Case IsDate ?
MsgBox "this is a date"
End Select
How can I accomplish this?