Command Button

[champ96]

Hi

I am quite a newbie in this ant therefor I am writing here to hope that someone can help me.

Have been searching a lot of forums, but can`t find what I am looking for (or maybe I dont understand). One of the 2 it is.

What I have a problem doing is as follows.

I have a workbook with multiple sheets.
I have some command buttons in one sheet called "project" which I want to count a -1 in cell d8 in a sheet named "stock"

Getting the button count a -1 in same sheet as the button I can make happen, but how do I write this to make it happen in another sheet??

Range("d8").Value = Range("d8").Value - 1

I am sure that there are lots of people here that can this, and hope that someone will take the time to help me.

Best Regards
Champ96

[john55]

hi,
maybe this

Please Login or Register  to view this content.

[champ96]

Thank you very much.

After a little bit editing it worked flawlessly.

Thanks again

[john55]

if it works...glad I could help u!