Private Sub CboNodeid_Change()
With TxtNodeDescription
If CboNodeid.Value = "" Then
TxtNodeDescription.Value = ""
Else
TxtNodeDescription.Value = Application.VLookup(CboNodeid.Value,
Range("nodedetails"), 3, False)
End If
End With
End Sub
this is my code to do the same