Userform Vlook Up

[Santosh Vishwakarma]

Dear All,

I have created a userform and need help to aviod the manual error which happens in updating city State and Zone.

If Mumbai Is selected by Default State and Zone should be updated.

I Tried using list box which worked but unable to edit in city field in many cases.

Some City are mentioned in Sheet(Zone).

Thanks a lot in advance.

Regards,
Santosh Vishwakarma

 

[Deepak]

Hi,

Welcome here!!

I am little confused about your requirement.

Are u looking that Zone should auto get updated upon change in City then try this.

Private Sub TextBox3_Change()
Me.TextBox19.Value = "'"
On Error Resume Next
Me.TextBox19.Value = Application.VLookup(Me.TextBox3.Value, Sheets("Zone").[B1:D230], 2, 0)
On Error GoTo 0
End Sub

Else pls explain.