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

cristopulo

New Member
Joined
Aug 12, 2015
Messages
14
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
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,095,396
Messages
5,444,233
Members
405,275
Latest member
RefreshSQL

This Week's Hot Topics

Top