Open UserForm next to mouse pointer?

[richardcranney]

Hello, wondered if anyoen could help. Im new to this forum and hav
been programming in excel for about a year now, but im wanting to ope
a userform next to the mouse pointer. Ive seen this done before, bu
cannot pull the code from anywhere.

I have a button (commandbutton) which calls a userform to open, th
only thing i want it to do is open next to the mousepointer when th
button is clicked.

Can anyone help?

Many thanks

Richar

 

[Tom Ogilvy]

This isn't exactly what you want, but may give you some ideas:

http://www.cpearson.com/excel/FormPosition.htm

 

[richardcranney]

Hi, sorry, i've just changed the title of this message as its something
different im looking for.

I've been able to change the menus at the top of excel, next to help,
adding a new menu structure in there now.

I was wondering, when you right click anywhere in excel, it opens a
menu that is diffferent depending on what you click. is it possible to
open a menu when left clicking on a button?

Thanks