Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
This code add a button to the "standard" command bar of the visual editor window ? Does someone know why it does not work ? and what to change to make it work. '--------------------- Sub Test() With ThisWorkbook.VBProject.VBE.CommandBars("Standard") With .Controls.Add(msoControlButton) .Style = msoButtonWrapCaption .Caption = "Recherche" .OnAction = "Module5.test1" End With End With End Sub '--------------------- Sub test1() MsgBox "Good afternoon" End Sub '--------------------- Thank in advance for you time. Salutations |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button visual delay | Excel Programming | |||
Command Button Always Visible in window | Excel Discussion (Misc queries) | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
Add standard button on custum commandbar | Excel Programming | |||
Embedded command button doesn't respond in new window | Excel Programming |