Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add DropDown at Runtime Visual Studio Shared AddIn
Hi
I have created a shared add in for Excel using Visual Studio.NET 1.1. Please note I am NOT using Visual Studio Tools for Office. I am trying to add a combo box to the active worksheet at runtime. I am not able to figure out what code to do so. The following approaches DONT work ActiveSheet.OLEObjects.Add(ClassType:="Forms.Combo Box.1", Link:=False, _ DisplayAsIcon:=False, Left:=65.25, Top:=40.5, Width:=72, Height:=18) ActiveSheet.DropDowns.Add() From within the code the OLEObjects and DropDowns class dont have the Add method. I can use the Add method from VBA but not from VS.NET. Is it even possible to do this in VS.NET ? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add DropDown at Runtime Visual Studio Shared AddIn
Replying to my own post here. But if any of you guys are trying to do something similiar here is the working code string []vaProducts={"Water", "Oil", "Chemicals", "Gas"}; Worksheet xlwsSheet; xlwsSheet = (Worksheet)_excel.ActiveWorkbook.ActiveSheet; Range Target; Target = xlwsSheet.get_Range("A9","A9"); Excel.DropDowns xlDropDowns; Excel.DropDown xlDropDown; xlDropDowns = ((Excel.DropDowns)(xlwsSheet.DropDowns(Missing.Val ue))); xlDropDown=xlDropDowns.Add((double)Target.Left,(do uble)Target.Top,(double)Target.Width,(double)Targe t.Height,true); for (int i=0;i<vaProducts.Length; i++) { xlDropDown.AddItem(vaProducts[i],i); } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
visual studio | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Visual Studio | Excel Programming | |||
Visual Studio for Office ?? | Excel Programming |