Are TextBox14 and Checkbox1 on Worksheets(8) ?
(Better described as Sheets("Sheet8") or Sheet8)
or
are they on a Userform?
Assuming they are on Worksheets(8) put this in the module for Worksheets(8) not in a standard module
To get the correct sheet module select Worksheets(8), then Right Click on the sheet tab and then click > view code
Paste this in the resultant window/pane
Let us know how you get on with this, I can see a few problems that might arise later.
Hope this helps.
However
If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Bookmarks