Command Button to search data and populate fields in a userform

[kidwispa]

Hi,

I have very little experience with VBA in Excel and would really appreciate some help, as I've tried searching for what i need and I can't find anything specific on google.

I am in the process of creating a userform that will show company details, and would really like it to be able to enter an account number which when the command button is clicked, will populate other company details on the form.

I currently have the following fields:

TextBox25 - this is the field where the account number will be entered

CommandButton5 - this is the button I would like to click in order to search for the account number input in TextBox25, and populate the below fields:

TextBox26 - Company Name

TextBox28 - Company Address

The data that it will be searching from is in a tab entitled 'Company Details' and the relevant data is in the following columns:

Account Number = Column A
Company Name = Column C
Company Address = Column J

I hope this makes sense to somebody out there and would like to thank you in advance for any help given!

 

[kidwispa]

Forgot to mention - I'm using MS Excel 2003

Thanks

 

[texasalynn]

take a look at this post

also you might do a search on this site as there are some great suggestions realted to that topic.

 

[kidwispa]

Thanks for taking the time to reply - I will have a search through the forum and see what I can find, although the link you gave me seems to be related to listboxes/comboboxes which I don't think would necessarily be the best option for what I need to do - currently we have over 7,000 different account numbers and the user that would be inputting them would know the exact code they required, so I think keying the account number into a text box and then using a command button to search and populate the other required fields would be the ideal choice if possible.