Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leef
 
Posts: n/a
Default ? sort data in a drop down box w/ initial cell entry

I have a dorp down box w/ numeric data sorting in ascending order. Can I
enter a number in the cell, ie: '6' and then hit the drop arrow to have the
data sort to numbers starting with '6' as opposed to always starting at the
top of the data list and having to scroll down to the data of choice
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default ? sort data in a drop down box w/ initial cell entry

If the dropdown list is from data validation, it doesn't support
autocomplete. If you can use programming, there are instructions here
for adding a combobox from which you can select one of the values from
the data validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html

Leef wrote:
I have a dorp down box w/ numeric data sorting in ascending order. Can I
enter a number in the cell, ie: '6' and then hit the drop arrow to have the
data sort to numbers starting with '6' as opposed to always starting at the
top of the data list and having to scroll down to the data of choice



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying data from seperate sheet upon drop down box entry keeper Excel Worksheet Functions 1 May 19th 06 07:29 PM
Data entry - Copy contents of cell typed in one cell to another ce danie Excel Worksheet Functions 2 March 16th 06 06:51 PM
Lock Cell After Data Entry Ripper Excel Discussion (Misc queries) 1 February 28th 06 08:17 PM
Cell data format falloutx Excel Discussion (Misc queries) 1 February 10th 06 01:46 PM
Add data to cell w/o loosing initial data jaycain Excel Discussion (Misc queries) 2 March 29th 05 02:23 AM


All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"