Reset Value in cells to 0 after clicking the command button

**STU22** · 12-27-2012, 11:16 AM

I add a value to cells L4,L5,L9,L10,L11,L12,L13,L14,L15
I have a Comand button, when pushed it sends data to another work sheet in the same workbook. After I push the command button I would like the value in the cells listed above to return to 0. What can I do to the code listed below to make this happen?

Please Login or Register  to view this content.

Moderators Note: Please follow Forum Rule #3 and use code tags. Added this time, but please use them in the future…Thanks.

**stnkynts** · 12-27-2012, 11:32 AM

Just add this at the very end of your code. You will need to change the sheet name to be whatever the sheet name in which you want to change the values is.

Please Login or Register  to view this content.

**STU22** · 12-27-2012, 11:47 AM

Works great! Thank You

Reset Value in cells to 0 after clicking the command button

LinkBack

Thread Tools

Rate This Thread

Display

Reset Value in cells to 0 after clicking the command button

Re: Reset Value in cells to 0 after clicking the command button

Re: Reset Value in cells to 0 after clicking the command button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions