In Excel how to autofill a cell that references a list?

5 pts.
Tags:
ComboBox
Microsoft Excel 2003
microsoft excel functions
VB.NET
I have defined a list.

Now I am at the drop down on another sheet.  Instead of scrolling to the item in the list...  (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input.  Much like a combo box can operate in VB.net.

Any help will be greatly appreciated

Rick D Norris, CPA



Software/Hardware used:
Excel

Answer Wiki

Thanks. We'll let you know when a new response is added.

Rick when you look at the top on your excel you can see a column of taps which provide you with options.
select one cel than look at the fare end of the column for an optional of “fill”.
click on it than more options will appare than click on series
A small plot of options will appare
In series in choose column and in type choose autofill than OK

Than from there all your Cels will be autofilled.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following