addltem...? meherere codes ansprechen
01.11.2007 23:22:00
Lukas
Public Sub Kombinationsfeld()
Dim Auswahl As String
For I = 1 To CommandBars.Count
If CommandBars(I).Name = "Symbolleiste6" Then
CommandBars("Symbolleiste6").Delete
End If
Next
Set Symbolleiste6 = CommandBars.Add(Name:="Symbolleiste6", Position:=msoBarFloating, _
Temporary:=True)
Symbolleiste6.Visible = True
Set Kombifeld = Symbolleiste6.Controls.Add(Type:=msoControlComboBox)
With Kombifeld
.AddItem "Option1"
.AddItem "Option2"
.AddItem "Option3"
.AddItem "Option4"
.Style = msoComboNormal
.OnAction = "Auswahl"
End With
End Sub
Public Sub Auswahl()
MsgBox "Sie haben die Auswahl geändert"
End Sub