View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aferriere aferriere is offline
external usenet poster
 
Posts: 2
Default 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