Search data/Get data from worksheet by userform

[uday]

Hi,

I have attached one excel file which has userform. I want to sync that userform with worksheet data.

After giving the system ID if I click on the search button all other information(Address,city,state,pin code) will be automatically retrieve from the worksheet data.

If give the wrong system ID then one message box will pop up with notification (Wrong system ID)

If anyone keep the system ID textbox blank and click on the search button then another message box will notify me that "Please enter the system ID"

Regards
Uday Roy

 

[wudixin96]

See ,is a solution ??

 

[uday]

Thanks....working like a charm