Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
in MsExcel Help I found a description to create a ComboBoxHandler ( searching for "change event". But code is not functional. ComboBoxHandler is an unknown Type : Private ctlComboBoxHandler As New ComboBoxHandler Sub AddComboBox() Set HostApp = Application Dim newBar As Office.CommandBar Set newBar = HostApp.CommandBars.Add(Name:="Test CommandBar", Temporary:=True) Dim newCombo As Office.CommandBarComboBox Set newCombo = newBar.Controls.Add(msoControlComboBox) With newCombo .AddItem "First Class", 1 .AddItem "Business Class", 2 .AddItem "Coach Class", 3 .AddItem "Standby", 4 .DropDownLines = 5 .DropDownWidth = 75 .ListHeaderCount = 0 End With ctlComboBoxHandler.SyncBox newCombo newBar.Visible = True End Sub Does anybody know, which library is containing that control ? Thanks in advance Gulli |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
Create dictionary of terms, create first time user site | New Users to Excel | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) |