Excel VBA - Userform vlookup error handling
<p>I have a userform with a combobox populated with product names from my settings sheet, and I am trying to display a label with the product description once the user has selected a product from the combobox.</p>

<p>This works rather well, unless the user selects a product for which there is no product description, hence the vlookup would return empty and cause an error with the userform.</p>

<p>I tried several If Error - if is empty - Description is 0 - Description is empty statements , but none seem to work, including OnError GoTo Errorhandler. What am I doing wrong here?</p>

<pre><code>    Private Sub Problem_List_Change()

Description = Application.WorksheetFunction.VLookup(Problem_List.Text, Worksheets("Settings").Range("l3:o1000"), 4, False)

    If IsError(Description) Then
        Desc.Caption = ""
    Else
        Desc.Caption = Description
    End If

End Sub
</code></pre>

<p>thanks,
a2k</p>