Locking combo box into a cell?
I am using combo boxes from the forms toolbox to create drop downs. I need to
use the information in the drop downs for a macro into another form. All of the combo boxes float on the top of the worksheet, and when I format the box, the "move and size with cells" option is grayed out and inaccessible. How do I tie these objects into the sheet? |
Locking combo box into a cell?
Use a ComboBox from the Control Toolbox to get "move and size with cells"
Gord Dibben MS Excel MVP On Sun, 18 Jan 2009 08:31:01 -0800, driscolp wrote: I am using combo boxes from the forms toolbox to create drop downs. I need to use the information in the drop downs for a macro into another form. All of the combo boxes float on the top of the worksheet, and when I format the box, the "move and size with cells" option is grayed out and inaccessible. How do I tie these objects into the sheet? |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com