Hi all,

I have an easy question, but cannot figure it out!

I have a ComboBox, cboFull, with drop-down values of "Yes" and "No". When "Yes" was selected, I want this cell (13, 13) to be updated with "Yes", and when "No" was selected cell (13, 34) must be updated with "No".

I have tried the following stuff (obviously didn't work):

Select Case Me.cboFull.Value
            Case "Yes": WS.Cells(13, 13).Value = "Yes"
            Case "No": WS.Cells(13, 34).Value = "No"
End Select
and this....:

If Me.cboFull.Value = "Yes" Then WS.Cells(13, 13).Value = "Yes"
If Me.cboFull.Value = "No" Then WS.Cells(13, 34).Value = "No"
Thank you!