Run time error 1004 unable to get the vlookup property of the worksheet function class

[surajitbose]

As a new user of vba i have created a user form to enter doctors database. in the form i have
combobox1 Row source worksheet 'Teritory!A2:A52'
TextBox2 to generate a code(A,B,C...) based on the area. Source of the Area code is 'Teritory!B2:B52'
My code is as follows

Please Login or Register  to view this content.

Working fine unless i am entering an area which is not included in the list. if i enter a area which is not in the list ('Teritory!a2:a52) i am getting an error massage 'Run time error 1004 unable to get the vlookup property of the worksheet function class' . Please help me to handle the error.

[JBeaucaire]

You'll need to trap for error and give alternate instructions for when the error occurs:

Please Login or Register  to view this content.