Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How to Place a Check Mark Next to an Item in the Submenu of a Custom Menu

Hi All,

This is how you put it next to an item in the custom made menu:

Sub check_Received()

Dim mypopup As CommandBarPopup
Set mypopup = CommandBars(1).Controls("My menu")

If mypopup.Controls("Received").State = msoButtonDown Then
'menu item unchecked
mypopup.Controls("Received").State = msoButtonUp
Else
'menu item checked
mypopup.Controls("Received").State = msoButtonDown
End If
End Sub

How do you go about an item in the submenu of the same menu (("My
menu")?

Cheers
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How to Place a Check Mark Next to an Item in the Submenu of a Custom Menu

Can it be that nobody in this group knows the reply to this question?


On Thu, 05 Jul 2007 12:36:08 +0200, Evil Bumblebee
wrote:

Hi All,

This is how you put it next to an item in the custom made menu:

Sub check_Received()

Dim mypopup As CommandBarPopup
Set mypopup = CommandBars(1).Controls("My menu")

If mypopup.Controls("Received").State = msoButtonDown Then
'menu item unchecked
mypopup.Controls("Received").State = msoButtonUp
Else
'menu item checked
mypopup.Controls("Received").State = msoButtonDown
End If
End Sub

How do you go about an item in the submenu of the same menu (("My
menu")?

Cheers


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
How do I create a small box I can place a check mark in? PAM Excel Discussion (Misc queries) 8 November 7th 05 01:46 PM
How can I place check mark Paul T Excel Discussion (Misc queries) 2 October 3rd 05 04:25 PM
Menu Item check mark?? Derrick[_3_] Excel Programming 1 April 1st 05 06:36 PM
Adding a check mark to the custom made toolbar/menu continue...... aiyer[_59_] Excel Programming 0 September 2nd 04 12:52 AM
Add submenu to custom menu Excel[_3_] Excel Programming 1 July 23rd 03 08:07 AM


All times are GMT +1. The time now is 02:22 AM.

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"