Validation list isssue

jperman

New Member
Joined
Jan 25, 2005
Messages
1
I want to create a very large validation list (approx 685 records). How can I get it so that when people using the spreadsheet start to type a word from the validation list ir automatically fills in for you (such as in IE when your typing a web address you have already visited).....Any guidance would be great as my customers are fussing about looking through a list so long and manually picking out what they need.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
I don't think it is actually possible using validation.

I think you need to use a combobox from the Control Toolbox toolbar.
 

TiTuS

Board Regular
Joined
Nov 10, 2004
Messages
238
Can anyone help on how to do it with a combo box then? ive got the same problem. any way to this would be greatly appreciated
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
Titus

What do you actually want to do?
 

TiTuS

Board Regular
Joined
Nov 10, 2004
Messages
238
well the full extent of what i want to do is massive so im learning the idervidual errors to build up to that, but for now i have a databse of song slides for a powerpoint presentation i want a drop down box of all songs so i can say type in "Wh" and it will come up with the songs with the start word "What"
So how can you make a list box or some kind of box in excel to do this kind of thing? ive searched all over but have found nothing... either im looking for the wrong thing or just theres nothing out there (which i highly doubt)
In advance Thanks for your time!
 

Forum statistics

Threads
1,148,525
Messages
5,747,203
Members
424,068
Latest member
Salim khamis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top