Posted to microsoft.public.excel.programming

Kobus

external usenet poster

Posts: 22

Checking a Date format

Hi

I have a cell in a worksheet that will hold a date. This date is used to
calculate the decayed value of radioactive sources. When the sheet is
deactivated I want to check whether the value in the cell is in a proper date
format. If not, then a message will be displayed and the sheet re-activated.
How can I check, using code, that the date is in a correct format?

Thanks all

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
Checking a cell's format in a function	FilJ59	Excel Worksheet Functions	1	March 10th 09 09:55 PM
Format Checking	George	Excel Discussion (Misc queries)	1	March 9th 09 04:16 PM
Checking a cell conditional format	basilio	Excel Worksheet Functions	7	November 29th 08 08:45 AM
Date checking	Johnny	Excel Programming	2	July 27th 04 06:47 AM
checking the format of a string in a cell	Corbin[_6_]	Excel Programming	3	June 11th 04 01:27 PM

All times are GMT +1. The time now is 09:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us