popup menus by right click

[Guest]

Hi,

Thanks to anyone who can help.

From research in the 2007 help pages it would seem that menus can be created
in vba thsat popup in response to right click. However there is very little
sample code to help me understand what to do.

Presumably this code should be added in the form's open or load event? Can
anyone give me a sample to create a popup with 3 options to copy, paste and
run a macro? From there on I should be able to figure the rest out for
myself. Code to delete the popup on exiting the form might also be helpful.

 

[Guest]

Do you really want to create these at run time? Why not create them in
design mode?

I have not used 2007 yet, but this is really pretty simple in 2000, XP, and
2003.

Dale

 

[Guest]

Hi Dale,

As far as I can tell from 2007 help pages this is no longer possible except
via vba. Yes it was easy in 2003 I did it all the time.

 

[Dale Fye]

Fortunately, I'm working for an organization (US Govt) that usually takes
about 2 years to upgrade to the latest product, so when I get around to
needing to know this stuff, most of it will already have been figured out.