DropDownBox - Visual Basic Checking

16 Views

hi experts,

I have a dropdownbox for an IP workbook.

I want to check the choosed value in visual basic code, but I don't know how to check it. If I write :

If Cells(20, 7) = "" Then

MsgBox ("G20 is null")

End If

It doesnt work .

Any idea?

Thanks a lot!