Hi Sanjay,

'-----------------
What I'm after if possible is that when the user clicks a cell, the userform
is displayed, but at the moment the only option I can see is if the cell is
changed then the userform can be displayed.
'-----------------

Have you tried the code?

The Worksheet_SelectionChange event responds to a change
in selection; the Worksheet_Change event responds to a (non
formula) value change.


---
Regards,
Norman