I have some rows that contain a checkbox in the first column. If that box isn't checked, I want the user to be prompted with a MsgBox when an edit is attempted on any cell in that row.
I have some rows that contain a checkbox in the first column. If that box isn't checked, I want the user to be prompted with a MsgBox when an edit is attempted on any cell in that row.
you can do this with some VBA code on the worksheet change event, could you supply a sample of this to work with?
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Currently I have code that changes the color of the row depending on the checkbox status. By default the checkboxes are not checked and the rows are given a "grayed out" color. Once they check the box the row is made normal with white fill and black text.
It's when the checkbox is unchecked that I want the MsgBox to appear when an edit on the row is attempted.
Please Login or Register to view this content.
could you attach the workbook?
I can't upload the actual workbook due to the information, but here's a basic one with essentially what's happening.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks