Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |