View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Watkins Jim Watkins is offline
external usenet poster
 
Posts: 1
Default Testing for Date Format in VBA/Excel

I'm looking for a way to test, in an Excel VBA subroutine, whether a specific
cell value is (1) a numeric value that has been formated as date, (2) a
numeric value that has been formated as time, or (3) a "reggular" numeric
value.