View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aileen aileen is offline
external usenet poster
 
Posts: 78
Default Insert Formula based in cell user clicks

In need to insert a simple formula into Column J based on the cell in the
same row which is clicked by the user. Only one of the cells will be clicked
and color changed between the following cells F,H,L,M or N. The formula is
the product of 3 cells, 2 of which are fixed and the last one should become
whichever cell the user clicks.

e.g.

Cells(j, "J") = Cells(j, "E") * Cells(j, "I") * clicked cell(either cell F,
H, L, M or N)


Is this possible to do?