View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Watkins[_2_] Jim Watkins[_2_] is offline
external usenet poster
 
Posts: 1
Default Testing for type of cell value using Excel VBA

I'm liiking for a way to determine which of the following is true regarding
the value & format of a specific cell: Does the cell have a (1)
date-formated number, or (2) a time-formated number, or (3) a numeric value
that is neither date-formated nor time-formated.