I am currently working on a worksheet that has a dropdown list with the
following values in cell B3
Structured Walkthrough
Formal Inspection
Passaround Review
If Structured or Passaround is selected I would like cell B38 to
display "N/A"
But if it is Formal Inspection I would like a formula to be inserted
into cell B38
"=b11(b7/b6)"
I know this is probobly simple, I have not used
VB in conjuction with
Excel before.
Thank you in advance for your help.
Larry
---
Message posted from
http://www.ExcelForum.com/