Date formating problem in EXCEL 2003

macropod · #1 01-05-2012, 09:37 PM

Hi lyngio,

The culprit is your 'Worksheet_Change' macro. Change:
Target(1).Value = UCase(Target(1).Value)
to:

If Not IsDate(Target) Then Target(1).Value = UCase(Target(1).Value)

lyngio · #2 01-27-2012, 03:37 AM

Quote:

Originally Posted by macropod

Hi lyngio,

The culprit is your 'Worksheet_Change' macro. Change:
Target(1).Value = UCase(Target(1).Value)
to:
If Not IsDate(Target) Then Target(1).Value = UCase(Target(1).Value)

Sorry it's taken a while for me to get back but I've been on holidays...
Anyways, Fantastic........Works a treat now!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
word 2003 date picker	nashville	Word	16	04-06-2012 04:12 AM
Problem with opening xlsm in excel 2003	cryjoh	Excel	2	12-13-2011 11:49 AM
Excel 2003 / 2007 files saving slow on Win 2003 Server	Atradius	Office	0	07-23-2011 07:41 AM
Excel 07 formating 17 cells "Need Formula"	Raner	Excel	2	05-30-2010 02:07 PM
Excel Date Alert?	Kelleigh	Excel	1	12-05-2008 09:35 AM