PC Review


Reply
Thread Tools Rate Thread

custom popup menu in cell

 
 
roy@mgk.com
Guest
Posts: n/a
 
      10th Apr 2007
i want to create custom popup menu triggered when user right-clicks on
cell. i will create this menu on workbook open and 'switch' it with
the default 'cell' menu on the Worksheet_BeforeRightClick event. can
someone help me with syntax where i've placed the "??"s..............
Thanks very much

here is the code....

sub createMenu
dim myRS as adodb.recordset
dim myGlobalMenu as popUpmenu

set myRS...........

while not myRS.eof and myRS.bof
...add new menuItem to popup menu here...
??
.caption = myRs!name
.tag = myRs!ur
.action addUrl ( pass menuItem object to sub "addURL")
myRs.movenext
wend

end sub

sub addUrl (aMenuItem as menuITem)
' add caption to current cell
??
' add url to right of current cell
??

end sub

Worksheet_BeforeRightClick
' replace current cell popup menu with myGlobalMenu
??????
end sub

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying A custom menu as a popup menu =?Utf-8?B?ZGlkZHlfZGF2aWQ=?= Microsoft Excel Programming 5 22nd Sep 2007 04:40 AM
Custom Floatable Toolbar Popup Menu =?Utf-8?B?UGZsdWdz?= Microsoft Excel Programming 6 14th Jun 2007 03:51 PM
Tooltips won't show up in custom popup menu =?Utf-8?B?QnJpYW4gSi4gTWF0dXNjaGFr?= Microsoft Excel Programming 1 16th Nov 2005 09:13 PM
How do I access the parameter property of a Custom popup menu in . =?Utf-8?B?bWFkdG93bmNwbA==?= Microsoft Access VBA Modules 1 15th Oct 2004 07:29 AM
Custom Popup menu in custom control and powerpoint Rajesh Microsoft Powerpoint 1 1st Mar 2004 01:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:35 AM.