I need two things:
1) According to checkbox's selected, put in the same column Name in Worksheets("Tapasois") the word "SIM" OR X ( At the end of the "ENVELOPES" Sheet - although this needs to be able to introduce new columns and then adjust programmation)
Let me better explain:
In Sheet2 i have a table, and in somecolumns i have the production sections ("Bolha, Embalagem , Serigrafia, etc etc") - Which i have too in the Checkbox's Caption
What i need is, according to checkbox's selected put the word "SIM" in the last filled row in Sheet2 columns of the section.
Probably i can do this with IF Checkbox1.Value = True then put in Cell X the word "SIM" put let me know if there is a better way.
My 2nd need would be to change a little bit the Msgbox of the checkbox's select
The Checkbox's are according to Master Sections like, "Production , expedition , packaging"
Checkbox1 , 2 , 4 are from Production
Check 3 , 5,8 are from expedition
Checkbox 6,7 are from packaging
Display a Msgbox saying according to checking box value:
"The following sections were printout"
From Production:
Checkbox1.caption
Checkbox2.caption
Expedition:
None
Packaging:
Checkbox7
This is an exemple for Check1,2 and 7 pressed.
File is attached, hope someone can help me out
Thank you very much for your help in advance.
Bookmarks