Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box and Sorting
I have a spreadsheet that I want to put a combo box on each row. The user
selects a treatment type for each item in the row. You can sort the worksheet and the combo box will stay with that row. However, it's still linked the the same cell. For example, if it is linked to N2, I can sort the spreadsheet by name. The combo box may now be in N100 but it is still linked to N2. Is there a way to link it after you sort the spreadsheet. -- Arkansas Lady |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box and Sorting
Hi,
It might be better to use Data, Validation, List rather than a combo box? If you are using a Control Toolbox combobox then there is a Format option to move and size with cells. That option isn't the same for Form comboboxes. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Arkansas Lady" wrote: I have a spreadsheet that I want to put a combo box on each row. The user selects a treatment type for each item in the row. You can sort the worksheet and the combo box will stay with that row. However, it's still linked the the same cell. For example, if it is linked to N2, I can sort the spreadsheet by name. The combo box may now be in N100 but it is still linked to N2. Is there a way to link it after you sort the spreadsheet. -- Arkansas Lady |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box and Sorting
David,
I'm looking at that option now. What I want to do is put in text where the user can only select four options. Floor, Sides, etc. Thanks so much. -- Arkansas Lady "Shane Devenshire" wrote: Hi, It might be better to use Data, Validation, List rather than a combo box? If you are using a Control Toolbox combobox then there is a Format option to move and size with cells. That option isn't the same for Form comboboxes. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Arkansas Lady" wrote: I have a spreadsheet that I want to put a combo box on each row. The user selects a treatment type for each item in the row. You can sort the worksheet and the combo box will stay with that row. However, it's still linked the the same cell. For example, if it is linked to N2, I can sort the spreadsheet by name. The combo box may now be in N100 but it is still linked to N2. Is there a way to link it after you sort the spreadsheet. -- Arkansas Lady |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box and Sorting
David,
I'm so sorry, I didn't look close enough. I found the list option and it is working great! Thanks -- Arkansas Lady "Shane Devenshire" wrote: Hi, It might be better to use Data, Validation, List rather than a combo box? If you are using a Control Toolbox combobox then there is a Format option to move and size with cells. That option isn't the same for Form comboboxes. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Arkansas Lady" wrote: I have a spreadsheet that I want to put a combo box on each row. The user selects a treatment type for each item in the row. You can sort the worksheet and the combo box will stay with that row. However, it's still linked the the same cell. For example, if it is linked to N2, I can sort the spreadsheet by name. The combo box may now be in N100 but it is still linked to N2. Is there a way to link it after you sort the spreadsheet. -- Arkansas Lady |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Combo Box sorting | Excel Worksheet Functions | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |