| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select sort key from drop down box
With the help of people on this board I have managed to use an input box to
enter the column number to sort a range of cells. I now want to take it a step further. How can call a dropdown box listing the column headers so that a user can select which column to sort by? I also need to store the column numberas this is used in further code. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select sort key from drop down box
Pablo,
I have supplied a suggestion in the original thread. -- HTH Bob Phillips "pablo bellissimo" wrote in message ... With the help of people on this board I have managed to use an input box to enter the column number to sort a range of cells. I now want to take it a step further. How can call a dropdown box listing the column headers so that a user can select which column to sort by? I also need to store the column numberas this is used in further code. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with input box to select a sort up to 28 | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| Select rows, then sort | Excel Discussion (Misc queries) | |||
| Select and then sort a list | Excel Programming | |||
| Excel 2000 VBA Sort without Select | Excel Programming | |||
Linear Mode
