View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ssjody ssjody is offline
external usenet poster
 
Posts: 16
Default Vlookup What if not Found

How do I make this code not error if the value in cboCarPartModel is
not found in my wo worksheet? It works fine if the value is found but
errors if not found. Jody

Private Sub cboCarPartModel_Change()
Dim wo As Range
Set wo = Worksheets("cpModels").Range("cpModelNameAndNumber s")
If Me.cboCarPartModel.Value "" Then
Label3.Caption = Application.VLookup(cboCarPartModel.Value, wo, 2,
False)
End If
End Sub