Date formating problem in EXCEL 2003

		Microsoft Office Forums > Microsoft Excel > Excel
Date formating problem in EXCEL 2003

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-27-2012, 03:37 AM

lyngio

Windows XP Date formating problem in EXCEL 2003

Office 2003

Novice

Join Date: Jan 2012

Posts: 6

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!!

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 PM.