Thread: cell change
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default cell change

Are you sure you don't just want formulas in column B?

--
steveB

Remove "AYN" from email to respond
"Monique" wrote in message
...
I have a range of cells that will users can put information in. If anyone
of
those cells are entered then in a separate section of the same worksheet,
those numbers are used to calculate a percentage.

A B

1
2
3
4
5

Column B1 = A1 * A3
Column B2 = A5 * A2

etc etc.

I want Column B to automatically generate the answer upon a change in
Column
A.

I have read that worksheet_change would work.. but i'm not sure how that
will work with implementation of change in several different cells.

Any help would be greatly appreciated.
Thanks