Posted to microsoft.public.excel.programming

MJKelly

external usenet poster

Posts: 114

change event for cells within a range

Hi,

I want to run a macro if a cell within a certain range is changed by a
user.

eg, if a cell is changed within the range A1:A10 then the text color
of that cell changes from black to red.

can you help?

The only code I have so far is:-

Private Sub Worksheet_Change(ByVal Target As Range)

Target = Range("A1:A10")

End Sub

kind regards,
Matt

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
Problem with ComboBox, dynamic range and change event	Wim SKW	Excel Programming	2	June 21st 07 09:08 PM
Range object and worksheet change event	Paulymon	Excel Programming	3	September 26th 06 08:06 AM
Change Event Range Help	mastermind	Excel Programming	3	March 30th 06 01:30 PM
Change event triggered by a named range	Sean	Excel Programming	4	August 1st 05 03:01 AM
Change Event on a named range	GregR	Excel Programming	2	July 12th 05 09:37 PM

All times are GMT +1. The time now is 10:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us