Combo boxes
Is is possible to copy a combobox (and all its properties) into a whole
column? Each cell should have the drop down button. Many thanks |
Combo boxes
You can do that with Data/Validation on the Excel menu by pre-selecting the
range that requires the drop-down list and specifying the range where the list is located. -- Kevin Backmann "sedonovan" wrote: Is is possible to copy a combobox (and all its properties) into a whole column? Each cell should have the drop down button. Many thanks |
Combo boxes
thanks, but I need a combobox so that it can perform auto-complete or match
entry... "Kevin B" wrote: You can do that with Data/Validation on the Excel menu by pre-selecting the range that requires the drop-down list and specifying the range where the list is located. -- Kevin Backmann "sedonovan" wrote: Is is possible to copy a combobox (and all its properties) into a whole column? Each cell should have the drop down button. Many thanks |
All times are GMT +1. The time now is 07:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com