Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've added a commandbar (see code below) to my userform, which pops up
another userform. The first time I open this command bar and click on the POC Info button, it opens the second form properly, but when I select click on the label that pops this menu up a second time, there is a check in front of the POC Info option, and clicking on it does nothing. Any ideas what I am doing wrong? Sub OptionsMenu() Dim CmdBar As Office.CommandBar Dim ctrl As Office.CommandBarControl On Error Resume Next Application.CommandBars("MyOptions").Delete On Error GoTo 0 Set CmdBar = Application.CommandBars.Add(Name:="MyOptions", _ Position:=msoBarPopup, _ temporary:=True) Set ctrl = CmdBar.Controls.Add(Type:=msoControlButton) With ctrl .Caption = "POC info" .OnAction = "POC_Info" End With End Sub Public Sub POC_Info() Userform1.Hide frm_POC_Info.Show Userform1.Show End Sub Dale -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pass value to excel userform - is there a constructor? how to pass | Excel Programming | |||
Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up | Excel Programming | |||
Excel Addin works that works on a template workbook | Excel Programming | |||
it works, it doesn work, its works....and so on. | Excel Programming | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) |