Hello,
I have a situation here. If worksheet 1 has the following data :

A
1 CATEGORY
2 Income
3 Expenses
4 Junk
5 Others
6 Whatever

Assume all the values (A2 to A6 ) are in a dynamic Name range. "CATEGORIES".
These values are used in Sheet2. When I click on say A5 and change "Others"
to "SAMPLE", I want to display a messagebox and prompt for automatic
updating on the worksheet which uses these categories(Sheet2). How can I do
this ? Any suggestions from MVPs ?

Also,when we click in a cell and change a certain value, how can we get a
reference to the old value ? There must be a way, since Excel can put the
data back using the undo (ctrl+z) option. Which object is used for this ?
Any suggestions ? I am new to excel vba coding. Patience is appreciated.

Thanks