ExcelBanter - Testing for type of cell value using Excel VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Testing for type of cell value using Excel VBA (https://www.excelbanter.com/excel-programming/374655-testing-type-cell-value-using-excel-vba.html)

Jim Watkins[_2_]

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.

Tom Ogilvy

Testing for type of cell value using Excel VBA

use Vartype

See help for details.

--
Regards,
Tom Ogilvy

"Jim Watkins" wrote:

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.

All times are GMT +1. The time now is 01:26 PM.