ActiveX Check Box: Problems with clickable area

[ayukoizgosu]

Hi all,

I am currently on Windows XP and running Excel 2007.

I am having some problems with my ActiveX Check Box as illustrated below:

1. I click check box. The check box seems to be selected but not ticked.


-- removed inline image ---
=>
-- removed inline image ---


2. I click anywhere on the worksheet (doesn't have to be on the check box), the check box is ticked.


-- removed inline image ---
=>
-- removed inline image ---


This also happens when attempting to unticking a check box.The problem is I have a call macro if the check box is ticked or unticked.

I've been trying to scour the net for answers and I haven't been able to run into anyone who has had this problem before.

Welcome any suggestions to a way around this? Ideally I would like to continue using check boxes even though a data validation list is an option.

Cheers,

ayukoizgosu