Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation in excel 2000
i have a list of fund names say 1000.
i use data validation and want to select a particular fund name like a combo box does. but i dont want to scroll down all the way to see fund say for ex. T but as i type type T i shud go to all the funds named with T . this is like making it recognise the 1 st alphabet of the fund . can i do this or do i have to write a macro ? can anyone plsssssss help. can u mail me the answer at thanks a lot !!!!!!!! sam. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation in excel 2000
Data validation doesn't allow this. If you want this kind
of function, then you will need to use a combo-box. A macro won't help in this situation. -----Original Message----- i have a list of fund names say 1000. i use data validation and want to select a particular fund name like a combo box does. but i dont want to scroll down all the way to see fund say for ex. T but as i type type T i shud go to all the funds named with T . this is like making it recognise the 1 st alphabet of the fund . can i do this or do i have to write a macro ? can anyone plsssssss help. can u mail me the answer at thanks a lot !!!!!!!! sam. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation in Excel 2000 - Can 2 items from a list be combine | Excel Discussion (Misc queries) | |||
Excel 2000 Validation with colors | Excel Discussion (Misc queries) | |||
enlarge validation drop down box excel 2000 | Excel Discussion (Misc queries) | |||
Validation in Excel 2000 | Setting up and Configuration of Excel | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) |