ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combo Box sorting (https://www.excelbanter.com/excel-worksheet-functions/65714-combo-box-sorting.html)

Mosquitobait

Combo Box sorting
 
I have a three sets of combo boxes that are being answered by employees.
Once they have chosen an answer, I would like to sort by the answers, however
when I highlight the spreadsheet, the combo boxes do not highlight and sort.
Please help. Thanks!

Dave Peterson

Combo Box sorting
 
If you're using the comboboxes from the control toolbox toolbar, then rightclick
on each combobox and choose format|control

Specify "move and size with cells"

And make sure that the combobox is completely within the cell.

Mosquitobait wrote:

I have a three sets of combo boxes that are being answered by employees.
Once they have chosen an answer, I would like to sort by the answers, however
when I highlight the spreadsheet, the combo boxes do not highlight and sort.
Please help. Thanks!


--

Dave Peterson


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com