This happens when I'm interacting with cells that are linked to specific checkboxes. When I change the value of a cell, the linked checkbox doesn't change. However, sometimes when I close Excel and re-open the workbook and then change the value of the same cell again, the linked checkbox changes and functions as it should. Is this just a bug?
Last edited by machinegod; 12-11-2019 at 01:46 PM.
Hello machinegod,
If you are using a Worksheet_Change event in your workbook, it could be the cause. Often times Screen Updating is turned off in this event. If it is not activated before exiting the event, your screen and controls will not be updated.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you. I am using a Worksheet_Change event in my workbook. That's probably it.Originally Posted by Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks