Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've actually been lucky:
http://www.ozgrid.com/forum/showthread.php?t=23224 it looks like this would work. tricky.... Public Const g_strCBRName As String = "MyCustomBar" Sub CustomTB() Dim cbrTemp As CommandBar Dim objDrop As CommandBarControl RemoveCustomTB 'Create commandbar Set cbrTemp = Application.CommandBars.Add(g_strCBRName) With cbrTemp ' Add control Set objDrop = .Controls.Add(msoControlComboBox) With objDrop ' add items .AddItem "Andy" .AddItem "Bob" .AddItem "Charlie" .OnAction = "cbrTest" End With ' Add control textbox Set objDrop = .Controls.Add(msoControlEdit) With objDrop .OnAction = "ctxTest" End With .Visible = True End With End Sub Sub cbrTest() MsgBox "You selected " & Application.CommandBars(g_strCBRName).Controls(1). Text End Sub Sub ctxTest() MsgBox "You entered " & Application.CommandBars(g_strCBRName).Controls(2). Text End Sub Sub RemoveCustomTB() ' Try and delete commandbar On Error Resume Next Application.CommandBars(g_strCBRName).Delete End Sub Thanks Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding custom images to a button on custom toolbar | Excel Programming | |||
Adding a check mark to the custom made toolbar/menu continue...... | Excel Programming | |||
Adding a Custom Toolbar to an .xla, not to Excel globally | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |