Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a combobox
How do I insert a combobox programmatically into a
specific cell, say B4, that exactly fits the size of the cell? Stefan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a combobox
Option Explicit
Sub TestAdd() AddCombo Range("K5") End Sub Sub AddCombo(rTarget As Range) With rTarget ActiveSheet.OLEObjects.Add (ClassType:="Forms.ComboBox.1", _ Link:=False, _ DisplayAsIcon:=False, _ Left:=.Left, _ Top:=.Top, _ Width:=.Width, _ Height:=.Height).Select rTarget.Select End With End Sub Patrick Molloy Microsoft Excel MVP -----Original Message----- How do I insert a combobox programmatically into a specific cell, say B4, that exactly fits the size of the cell? Stefan . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox | Excel Worksheet Functions | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox | Excel Discussion (Misc queries) | |||
HELP PLEASE..Inserting combobox (ActiveX control) makes workbook c | Excel Discussion (Misc queries) | |||
ComboBox | Excel Programming |