Activate a UserForm by Right Clicking a Cell

[stupotk]

Hello All,

I'm not sure if this is actually possible without some sort of 'Add-In' but I thought I would ask anyway!
I have created a UserForm which I want to open when the user 'right clicks' a specific cell (for example, H8).
I have already been able to do it if the user left clicks on the cell by putting a code on the sheet, but this causes problems.
A right click utility would work perfectly I am sure.

Regards,

Stuart

[ragulduy]

If you already managed to do it for a left click you're going to kick yourself:

Please Login or Register  to view this content.

[stupotk]

Cheers yudlugar,

I am kicking myself as I type...
That worked perfectly. Although, I have used this code for a couple of other cells attached to UserForms, a few of them are merged cells eg (F7:G8).
The code doesn't work for these like my old code did, though I didn't really like my code anyway. I am sure it is a simple amendment to the code so that it works but I am quite new to VBA (as you probably guessed). If you could fix this for me that would be great.

Thanks again,

Stuart

[ragulduy]

Use this instead:

Please Login or Register  to view this content.

[stupotk]

Absolutely perfect.
Thank you so much! You have helped a lot - will change thread to Solved.

Stuart