-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Testing a date
- Thread starter smund
- Start date
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Like this:
<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> foo()
<SPAN style="color:#00007F">If</SPAN> ActiveCell = <SPAN style="color:#00007F">Date</SPAN> <SPAN style="color:#00007F">Then</SPAN>
MsgBox "Yup"
Else: MsgBox "Nope"
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>
HTH,
Smitty
<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> foo()
<SPAN style="color:#00007F">If</SPAN> ActiveCell = <SPAN style="color:#00007F">Date</SPAN> <SPAN style="color:#00007F">Then</SPAN>
MsgBox "Yup"
Else: MsgBox "Nope"
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>
HTH,
Smitty
Upvote
0
