Alter one cell value, in case another cell's value changed
Hello everybody
I am new in Excel macro programming
Is there any ways to fill some words "remarks" into Cell B2 in Eecel worksheet, in case Cell A1 value has been modified. I don't know how to inplement the actual Excel macro code but using pseudocode to represent my meaning, say
in Cell B, fill formula:
= If cells('A1').value != originalValue The
cells('B1').value = "Cell A1 has been modified on " & Date(
End I
Kindly tell how to convert the above meaning into extual Excel macro code
Thanks & regards
|