PDA

View Full Version : [SOLVED:] Changing the Value of the ComboBox



LordDragon
07-26-2015, 08:27 PM
Greetings & Salutations,

I have a small problem. I am trying to create reset button for my Workbook. I have most the code figured out, but I have added ComboBoxes and am not very familiar with them.

What I want to do is simply reset the value of the ComboBoxes to a certain value.

For example: I have 13 of these boxes that are simply "Yes" or "No" boxes. I want to set them all to "No". when the reset button is selected.

There are some other ComboBoxes with other values, but I mainly just need the starting point on how to change the value on any one of them.

Thanks.

LordDragon
07-26-2015, 08:42 PM
I figured it out.



Dim strNo As String

strNo = "No"

With ActiveWorkbook
.Worksheets("Project Info").ComboBox1.Value = strNo
End With