Posted to microsoft.public.excel.programming

external usenet poster

Posts: 126

Macro triggered by a cell value change

Hi

I like to have the VBA codes(Not Excel Formula) for the following;

I select Range("a1") and enter "OK"
I select Range("a5") and enter 3

Now if I change Range("a5") then Range("a1") should read "Error".

Thanks

Varnendra M

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
Macro for a one time triggered copy of cell value	Azrael[_2_]	Excel Discussion (Misc queries)	8	March 4th 09 04:24 PM
event triggered by cell format change?	Stefi	Excel Programming	4	January 10th 06 12:35 PM
Can a macro be triggered when a cell is selected?	Linking to specific cells in pivot table	Excel Programming	2	July 12th 05 07:28 AM
Event triggered by cell data change/entry	Fred Holmes	Excel Programming	3	March 17th 05 02:13 PM
macro triggered by a change to a cell	Lee	Excel Programming	2	July 3rd 04 12:04 AM

All times are GMT +1. The time now is 08:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us