View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline
external usenet poster
 
Posts: 237
Default 3 VBA Conditions(last edit)

Thank you. This helped.


-----Original Message-----
The basic structure here would be :-

'----------------------------------------------
If .......... Then
'code
ElseIf ............ Then
'code
ElseIf ........... Then
'code
Else
'code
End If
'-----------------------------------------

You could presumably do a similar search for ":" to get

time, or you
might find this useful :-

If IsNumber(c.Value) Then c.Value = "number"


---
Message posted from http://www.ExcelForum.com/

.