how to add a combobox in excel's cell with vb.net
-
Hi,everyone!I want to add a combobox in a cell of excel file with VB.net,but when I used sheet.shapes.addxxx fuction,I found that there were "addChart" and others but no addCombobox. :omg: What should I do could add combobox in a cell with vb.net?Please help and give me suggestion!Thanks a lot!
-
Hi,everyone!I want to add a combobox in a cell of excel file with VB.net,but when I used sheet.shapes.addxxx fuction,I found that there were "addChart" and others but no addCombobox. :omg: What should I do could add combobox in a cell with vb.net?Please help and give me suggestion!Thanks a lot!
You don't. ComboBox's sit on top of the sheet, not in it's cells.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
Hi,everyone!I want to add a combobox in a cell of excel file with VB.net,but when I used sheet.shapes.addxxx fuction,I found that there were "addChart" and others but no addCombobox. :omg: What should I do could add combobox in a cell with vb.net?Please help and give me suggestion!Thanks a lot!
In Excel 2007, you need to first display the Developer Ribbon from the Excel Options | Popular panel. Then on the Developer Ribbon, Insert Control | ActiveX Combo (Form Control Combo will be disabled) As Dave has already stated, the control sits on top of the sheet, and is not 'inside' a cell. They just happen to move relative to the cells where you placed them (by default), if you insert and delete / resize cells. You can change the move/resize action from the objects properties though.
Dave Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com -
In Excel 2007, you need to first display the Developer Ribbon from the Excel Options | Popular panel. Then on the Developer Ribbon, Insert Control | ActiveX Combo (Form Control Combo will be disabled) As Dave has already stated, the control sits on top of the sheet, and is not 'inside' a cell. They just happen to move relative to the cells where you placed them (by default), if you insert and delete / resize cells. You can change the move/resize action from the objects properties though.
Dave Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com -
You don't. ComboBox's sit on top of the sheet, not in it's cells.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...