I'm not exactly sure how to ask this question the right way so I'll just explain what I've got and what I'm trying to do with it.
Currently, I have an Excel spreadsheet that I created in order to list the bills that need to be paid. It has columns for vendor name, vendor number, invoice number, descrpition, account, etc, etc.
I created what I think is called a list box. It is located on the same page (off to the right). This box contains a listing of all of our vendors in one column, the next column contains vendor specific information and the third column contains the vendor number.
On the form itself, when you are in the vendor name column, you have to scroll down the entire list (which pulls from the list box) to find the correct vendor. When you do this and click enter, it will then place the correct vendor info and vendor number in the next two columns.
My question is, is there a way to modify this list box so that instead of scrolling down the entire list, we can just start typing the vendor name until it reaches that vendor and then hit enter?? I know I've seen this done before on other sheets but I don't know how to do it. It would be much easier and faster if we could do this.
Please keep in mind that while I have been succesful and a lot of Excel things (like this list box) I am FAR from an expert so simple language would be helpful.
Thank you so much.
Catherine
cat.reynolds@verizon.net
Currently, I have an Excel spreadsheet that I created in order to list the bills that need to be paid. It has columns for vendor name, vendor number, invoice number, descrpition, account, etc, etc.
I created what I think is called a list box. It is located on the same page (off to the right). This box contains a listing of all of our vendors in one column, the next column contains vendor specific information and the third column contains the vendor number.
On the form itself, when you are in the vendor name column, you have to scroll down the entire list (which pulls from the list box) to find the correct vendor. When you do this and click enter, it will then place the correct vendor info and vendor number in the next two columns.
My question is, is there a way to modify this list box so that instead of scrolling down the entire list, we can just start typing the vendor name until it reaches that vendor and then hit enter?? I know I've seen this done before on other sheets but I don't know how to do it. It would be much easier and faster if we could do this.
Please keep in mind that while I have been succesful and a lot of Excel things (like this list box) I am FAR from an expert so simple language would be helpful.
Thank you so much.
Catherine
cat.reynolds@verizon.net