View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RogerDaShrubber RogerDaShrubber is offline
external usenet poster
 
Posts: 1
Default Changing cell value depending on dropdown list

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/