VBA Code to Find and Display Records

[Kris12]

I am very new to VBA. I have created a userform in excel. The idea is the excel worksheet will be prepopulated with data. upon opening excel, the user is prompted to enter the account number, via input box. I have all of this so far. My problem is I have no idea how to once the account number is inputed to search the spreadsheet for the account number and have it populate my userform so it may be updated. Please any help would be so very much appreciated. I have attached file I am working on for your assistance.

[pike]

Hi Kris12

Try something like....

Please Login or Register  to view this content.

[Kris12]

Hi Pike -
you are amazing! it works where i can search and pull up the data to the spreadsheet. I am going to continue to work at having the userform be the item that is pulled up and displayed!!! Thank you so much, as this will help !

[skhalaili]

I am new to VBA. I have created a userform in excel, and would like to add a find code using the vendor #, so when I press find and put the vendor # if I have that vendor I want his data to appeare in that form so I can update it and if not a message appeare says not found. I have found a similar case here but when I tryed it It didn't work.
Also I want to write a code for the vendor # text and for the Vendor name to prevent any duplicate while entering data.If any one can help it would be so much appreciated. I have attached the file I am working on for your assistance.

[hitesh_asrani_j]

Hi Kris12

Try something like....

Please Login or Register  to view this content.

Hello,
I used the code But I am unable to pull more than one Record ( actually want to pull all the duplicate records as well)