Print count

[MarkDShark]

I have a print button set, but what i want it to do is when i press print, it will automatically add 1 to a cell to keep count of the prints. So say i already made 2 prints, a cell would show 2. When i print again, 1 is added to that cell to make a total of 3. Can a code be added to the print button code to achieve this? I have done this with a clear button, but that code i used doesn't seem to work with the print button. Hope you can help. Thanks!

 

[bensonsearch]

I have a print button set, but what i want it to do is when i press print, it will automatically add 1 to a cell to keep count of the prints. So say i already made 2 prints, a cell would show 2. When i print again, 1 is added to that cell to make a total of 3. Can a code be added to the print button code to achieve this? I have done this with a clear button, but that code i used doesn't seem to work with the print button. Hope you can help. Thanks!

under the coding for the button itself

dim asd as integer
 
asd = thisworkbook.sheets("Sheet1").range("A1").value
 
asd = asd + 1
 
thisworkbook.sheets("Sheet1").range("A1").value = asd

once again this goes under the print button code and just change the sheet and cell to be whereever you are wanting the info.

 

[MarkDShark]

Been gone for a few days. Tried the code and it works great! Thanks!

 

[bensonsearch]

Been gone for a few days. Tried the code and it works great! Thanks!

No problems, glad I could help