Posted to microsoft.public.excel.programming

Jim Watkins Jim Watkins is offline

external usenet poster

Posts: 1

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Format Problem - Date Overrides Format	Mary	Excel Discussion (Misc queries)	5	February 10th 10 05:49 AM
Excel 2000 date format cannot be set to Australian date format	Brian Jones	Excel Discussion (Misc queries)	1	March 30th 05 06:03 AM
Macro Date Testing	BKBK	Excel Programming	0	October 28th 04 05:42 PM
Testing Time /Date stamps of Files	Tom Ogilvy	Excel Programming	1	September 14th 03 07:49 PM
Testing Time /Date stamps of Files	Tom Ogilvy	Excel Programming	1	September 1st 03 05:38 PM

All times are GMT +1. The time now is 09:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us