|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
event with commanbar button right_click?commandbar button? These buttons are created like this: Public cb2 As CommandBar Set cb2 = CommandBars.Add("MyOptionsPopUp", _ msoBarPopup, _ MenuBar:=False, _ temporary:=True) With cb2 Set FileControl = .Controls.Add(Type:=msoControlPopup) With FileControl .Caption = "File" With .Controls.Add(Type:=msoControlButton) .Caption = "Open report (F3 OR O from the treeview)" .OnAction = "OpenReport" .FaceId = 23 End With etc. The purpose is to trigger context sensitive help on the menu. RBS If this a DotNet question? What CommandBar?
-- Show quoteHide quoteChris Hanscom - Microsoft MVP (VB) Veign's Resource Center http://www.veign.com/vrc_main.asp Veign's Blog http://www.veign.com/blog -- "RB Smissaert" <bartsmissa***@blueyonder.co.uk> wrote in message news:OttrgYrzFHA.904@tk2msftngp13.phx.gbl... > Would it somehow be possible to trigger an event on right-clicking a > commandbar button? > > These buttons are created like this: > > Public cb2 As CommandBar > > Set cb2 = CommandBars.Add("MyOptionsPopUp", _ > msoBarPopup, _ > MenuBar:=False, _ > temporary:=True) > > With cb2 > Set FileControl = .Controls.Add(Type:=msoControlPopup) > With FileControl > .Caption = "File" > With .Controls.Add(Type:=msoControlButton) > .Caption = "Open report (F3 OR O from the treeview)" > .OnAction = "OpenReport" > .FaceId = 23 > End With > > etc. > > > The purpose is to trigger context sensitive help on the menu. > > > RBS > "Veign" <NOSPAMinveign@veign.com> wrote in message fwiw, I assumed he was talking about this, extremely cool, control... y'all news:ekbTF7szFHA.3892@TK2MSFTNGP12.phx.gbl... > If this a DotNet question? What CommandBar? > > -- > Chris Hanscom - Microsoft MVP (VB) > Veign's Resource Center > http://www.veign.com/vrc_main.asp > Veign's Blog > http://www.veign.com/blog > -- were right though... I guess it was a dotnet question. vbAccelerator CommandBar Control http://www.vbaccelerator.com/home/VB/Code/Controls/Command_Bar/vbAccelerator_CommandBar_Control/article.asp -- Ken Halter - MS-MVP-VB - http://www.vbsight.com DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm Please keep all discussions in the groups.. I had thought the same thing but had vaguely remember DotNet having a
commandbar control - will know more once I install VS2005 (not beta)... -- Show quoteHide quoteChris Hanscom - Microsoft MVP (VB) Veign's Resource Center http://www.veign.com/vrc_main.asp Veign's Blog http://www.veign.com/blog -- "Ken Halter" <Ken_Halter@Use_Sparingly_Hotmail.com> wrote in message news:uDPiz7zzFHA.2132@TK2MSFTNGP15.phx.gbl... > "Veign" <NOSPAMinveign@veign.com> wrote in message > news:ekbTF7szFHA.3892@TK2MSFTNGP12.phx.gbl... >> If this a DotNet question? What CommandBar? >> >> -- >> Chris Hanscom - Microsoft MVP (VB) >> Veign's Resource Center >> http://www.veign.com/vrc_main.asp >> Veign's Blog >> http://www.veign.com/blog >> -- > > fwiw, I assumed he was talking about this, extremely cool, control... > y'all were right though... I guess it was a dotnet question. > > vbAccelerator CommandBar Control > http://www.vbaccelerator.com/home/VB/Code/Controls/Command_Bar/vbAccelerator_CommandBar_Control/article.asp > > -- > Ken Halter - MS-MVP-VB - http://www.vbsight.com > DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm > Please keep all discussions in the groups.. > It was a VBA question and was meant to got to Excel.Programming.
I don't use any .Net. RBS Show quoteHide quote "Veign" <NOSPAMinveign@veign.com> wrote in message news:OsbfX70zFHA.664@tk2msftngp13.phx.gbl... >I had thought the same thing but had vaguely remember DotNet having a >commandbar control - will know more once I install VS2005 (not beta)... > > -- > Chris Hanscom - Microsoft MVP (VB) > Veign's Resource Center > http://www.veign.com/vrc_main.asp > Veign's Blog > http://www.veign.com/blog > -- > > > "Ken Halter" <Ken_Halter@Use_Sparingly_Hotmail.com> wrote in message > news:uDPiz7zzFHA.2132@TK2MSFTNGP15.phx.gbl... >> "Veign" <NOSPAMinveign@veign.com> wrote in message >> news:ekbTF7szFHA.3892@TK2MSFTNGP12.phx.gbl... >>> If this a DotNet question? What CommandBar? >>> >>> -- >>> Chris Hanscom - Microsoft MVP (VB) >>> Veign's Resource Center >>> http://www.veign.com/vrc_main.asp >>> Veign's Blog >>> http://www.veign.com/blog >>> -- >> >> fwiw, I assumed he was talking about this, extremely cool, control... >> y'all were right though... I guess it was a dotnet question. >> >> vbAccelerator CommandBar Control >> http://www.vbaccelerator.com/home/VB/Code/Controls/Command_Bar/vbAccelerator_CommandBar_Control/article.asp >> >> -- >> Ken Halter - MS-MVP-VB - http://www.vbsight.com >> DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm >> Please keep all discussions in the groups.. >> > > "RB Smissaert" <bartsmissa***@blueyonder.co.uk> wrote in message You can't use CommandBars in "pure" VB and this group is for writing news:OttrgYrzFHA.904@tk2msftngp13.phx.gbl... > Public cb2 As CommandBar programs in "pure" VB. Is this question about VBA in an Office app? Sorry, it went to the wrong group.
RBS Show quoteHide quote "RB Smissaert" <bartsmissa***@blueyonder.co.uk> wrote in message news:OttrgYrzFHA.904@tk2msftngp13.phx.gbl... > Would it somehow be possible to trigger an event on right-clicking a > commandbar button? > > These buttons are created like this: > > Public cb2 As CommandBar > > Set cb2 = CommandBars.Add("MyOptionsPopUp", _ > msoBarPopup, _ > MenuBar:=False, _ > temporary:=True) > > With cb2 > Set FileControl = .Controls.Add(Type:=msoControlPopup) > With FileControl > .Caption = "File" > With .Controls.Add(Type:=msoControlButton) > .Caption = "Open report (F3 OR O from the treeview)" > .OnAction = "OpenReport" > .FaceId = 23 > End With > > etc. > > > The purpose is to trigger context sensitive help on the menu. > > > RBS > 
Other interesting topics
Is there a more elegant way to do this?
Command Button Sequence Avoid Overflow! populating combobox Update Workstations with new executable Need to know when a process is exited How many ORs can you have in ADODB form_load parameters - novice Scheduling Control Best way to have a subroutine modify more than one variable |
|||||||||||||||||||||||
