Right-click the Sheet Tab and select View Code
Paste this code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = "X"
Cancel = True
End Sub


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Nicole" wrote in message
...
Is it possible to have a cell automatically display an "X" when a user
clicks
on it e.g. using the onClick in VBA? The user does not want to use the
"tick
box" under the forms toolbar. He would like an "X" in a cell when he
clicks
on it or even double click. The worksheet will also be protected at the
end
so that only certain cells can be added. Is this possible? If yes, how
would
I go about it? Any ideas?

Regards

Nicole