Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 167
Default Exotic Menu Controls

I am trying to add different controls to my menu bars, but some control types
seem to require a different definition syntax than others. For example, I
can add a simple popup control using:

Set myPopup = myBar.Controls.Add(Type:=msoControlPopup)

But, I would like the control type to be "msoControlSplitButtonMRUPopup"
where the button includes a small drop down arrow on the right, as in the
Autosum control. When I use this syntax:

Set myPopup = myBar.Controls.Add(Type:=msoControlSplitButtonMRUP opup)

I get the error message: "Run-time error '5': Invalid procedure call or
argument." This same error is reached when I use many other control types
including msoControlSpinner, msoControlGraphicPopup, etc.

Why is this error occuring? Is it syntax? I would like to be able to use
different control types for my menus and toolbars.

Thanks,
Pflugs
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
exotic jewelry box angedeRunda Excel Discussion (Misc queries) 0 October 12th 08 01:22 PM
Controls in Sheets (Hide etc.) in Format Menu Not appearing Varne Excel Discussion (Misc queries) 8 September 19th 08 04:45 PM
Hide controls in a worksheet menu bar clara Excel Programming 1 March 28th 07 07:08 PM
Menu Controls Index micklloyd[_2_] Excel Programming 2 January 26th 06 05:34 AM
Exotic CheckBox Mark[_36_] Excel Programming 3 February 5th 04 03:56 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"