If Statement Combo Box

[radlernyc]

cb_BdMtgFee.value is a combo box with Yes and No as choices. I want to place an X in a cell if yes is selected. The code below does not work. Thanks for the help

If cb_BdMtgFee.value = "Yes" Then

    ws.Range("AW" & LastRow) = "X"
    
Else

    ws.Range("AW" & LastRow) = ""

End If

 

[Norie]

What type of combobox is it?

 

[radlernyc]

The comb box is in a vb userform. Its rowsource is a named range. The two value in the named range are Yes and No

 

[Norie]

And how is the code not 'working'?

Where is the code located?

 

[radlernyc]

The code is located in an event. Command OK fills a data sheet with the values from the form. When combo box is "Yes" it should fill a range with an X. It currently is not working, meaning the combo box is yes but the range does not receive an X.

ws.Range("AW" & LastRow) = "X"

 

[Norie]

What event is it in?

 

[radlernyc]

On Click

 

[Norie]

Of what?

 

[radlernyc]

On Click of a Command Button. On click all values are dumped into a sheet. However, I need the some cells to have an X in them, not "Yes". So I need a piece of code that logicall reads something like this:

If combobox is Yes Then

Cell A5 = x

End If


I have tried multiple variations of this logic, but havent gotten right yet. Thanks for the help