Posted to microsoft.public.excel.programming

Steph[_6_] Steph[_6_] is offline

external usenet poster

Posts: 92

Worksheet Change Event

Hello. Within the range of Sheet1 D4:D2500, how can I take a date that is
entered into a cell and convert the DAY to a 1, keeping all else the same?

So for example, if the user enters 12/15/2005 in cell D25, then I would like
the change event to trigger and convert that cell into 12/1/2005.

Thank you!

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
Worksheet Change Event	DCSwearingen	Excel Discussion (Misc queries)	1	October 10th 05 10:25 PM
Worksheet Row Change event	crazybass2	Excel Discussion (Misc queries)	4	December 8th 04 05:29 PM
Worksheet Change event	Libby	Excel Programming	2	October 26th 04 12:02 AM
Change Cell from Validated List Not Firing Worksheet Change Event	[email protected]	Excel Programming	3	October 4th 04 03:00 AM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us