View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
myBasic myBasic is offline
external usenet poster
 
Posts: 3
Default 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