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 theAdd 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