Because the Forms and ActiveX checkboxes were causing too many headaches (fiddly to format, slow to respond, etc), I made a form for our field technicians to complete that uses macros to change cell values from ACCEPT to REJECT when clicked. See attached file Book2.xlsm
Starting at cell F16 and downwards, if you click the cell it will change the value quite nicely. The problem is that if you quickly double click then select another cell, Excel crashes!
Can anyone please help me figure out why?
This is the code that is doing most of the work:
![]()
Please Login or Register to view this content.
Bookmarks