Click Cell To Open Userform

[Mooseman60]

Hi I have inserted the following code to open a userform when a blank cell is clicked. This works fine but what i need it to do is make it only open the userform when any of the Column A Cells A20:A174 are clicked. Is it also possible to make the user have to double click the cell to open the userform and disable the right mouse click

Please Login or Register  to view this content.

[davesexcel]

Try this

Please Login or Register  to view this content.

[Mooseman60]

Dave

That works perfectly thanks very much

[davesexcel]

No problem,
I suppose you don't require the Target.count part of the code, as you can only double click one cell anyway

[astropopostar]

What if you want to single click to do this?