IF / THEN Statement based on Option Button and Data Validation List

[cristopulo]

Hello,

I am trying to use an If /Then Statement in order to change the output of a program I am making. I want to be able to change the value of a cell (through a data validation dropdown), change a certain output and have this happen after a certain Option Button is selected.

For Example, the user Chooses Option Button 1. Then chooses a value from a data validation list. If the Value on this list chosen matches the one in the IF/ THEN Statement, this changes a certain output in the program.


Here is the code I have so far for the IF /THEN:
(I have gotten it to work if the value is already input when you make choose the option button)

If Range("B11")= "ESB 63" Then
Range("C8").Value = "COOL"
End If

Thanks!
-Chris