Correct way to implement floating combobox?
I think I'd consider using Data|validation on the cells in that column first.
See Debra Dalgleish's site for a bunch of instructions: http://www.contextures.com/xlDataVal01.html If that doesn't work, maybe just creating a single combobox and moving it to the activecell would be better than adding a lot of comboboxes. Rick K wrote: I need to provide a predefined list of options for a given cell on every row via dropdown. Can excel do this with a floating combobox refenced on that row via events and current cell or do I have to create a combobox on every row? This is basically a data entry sheet for customer and this is req. format? Any help on best practice will be greatly appreciated. Thanks -- Dave Peterson |
Correct way to implement floating combobox?
How old? It was added in xl97.
Rick K wrote: Will Data Validation work with office 2000 and older? And thanks for the link. It really helped. "Dave Peterson" wrote: I think I'd consider using Data|validation on the cells in that column first. See Debra Dalgleish's site for a bunch of instructions: http://www.contextures.com/xlDataVal01.html If that doesn't work, maybe just creating a single combobox and moving it to the activecell would be better than adding a lot of comboboxes. Rick K wrote: I need to provide a predefined list of options for a given cell on every row via dropdown. Can excel do this with a floating combobox refenced on that row via events and current cell or do I have to create a combobox on every row? This is basically a data entry sheet for customer and this is req. format? Any help on best practice will be greatly appreciated. Thanks -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 05:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com