View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joanne Joanne is offline
external usenet poster
 
Posts: 121
Default circular argument

I am trying to make a formula in a cell that will read the value the
user puts in the cell and multiply it by 40, giving me that as the cell
value instead of just the input.
I tried putting this in the cell
=d15*40 (in cell d15)
This gives me a circular argument error.
I suspect I might need to do it in vba, but where does it go in the vba.
I am still confused by the Change event on the worksheet and what all
goes there and how to line up the sequence of events. Oh my!
Thanks for any info you can give me
Joanne