Use a formula such as =C3=B3. When a new value is entered in B3, Excel will
automatically compute a new value in C3. In this case, C3 will be equal to
B3.

Tyro

"fryguy" wrote in message
...
how can i make an event macro to update the value in C3 when a new value
is
entered in B3 without the need to click an update button.

thanks,

fryguy.