ActiveX checkbox to insert a cell from a different workbook

I am fairly new to Excel, just a novice user, but I am attempting to get more in depth with the Visual Basics and Macros.
I am hoping I find the help in these forums to resolve my issues.

I have created a monthly expense sheet to view my payments and show me available funds.
My problem is the new year coming. I have been able, up to this point, to coping from one sheet (tab) to the other, but I am now adding in these ActiveX checkboxes. I want to check it to have it bring in the balance from the previous year workbook.

Is there a way to do this?

I apologize for the delay in my response. I have been very busy with the holidays and wasn't quite sure how to do what you asked of me. I hope this is good enough.

Absolutely correct; however, if it is unmarked, or false, it needs to be removed and go back to 0.00.

How can this be done??

Ok, this did not work when I tried to copy code and paste. I renames check boxes as they were different numbers, and instead of Loan, it is Home Loan. I changed these and it doesn't work in my worksheet.

I see, you used From controls rather than ActiveX controls.. Ok, let me change my check boxes and see if that makes a difference.

This is the actual workbook and worksheets.

Yes, if the box is unchecked, it should revert back to its prior state of 0.00. This is because sometimes the wrong box gets checked to begin with.

That is working beautifully, thank you.
I have to ask one more question though. Maybe two. LOL. I need to put ActiveX controls in all those cells going down, is there a way to do so instead of individually doing them and having them sized to the preset size?

I figure after they are all in, I can go back through and and the code.

Again, I thank you for your help thus far.

Joe Sargent

What is an event procedure or a button triggering???

Not all cells will need the code, but to be able to check the boxes as a bill comes in is helpful to me. I have had several head injuries and tend to forget things. This method helps me determine when a bills comes in and is paid also triggering the next sheet with the values from the previous.

Thank you for you compassion. I still do not know what you are talking about. LOL. Selection change event?? Doubleclick event?? The Home Loan fields would always be the same, just one below each month. The sheet you helped on is a budget sheet for January of this year. The next sheet to b added is February and so on.

No, I would have them all the way down doing different things. I will send post on line for you to look at in a little while. I gotta run a friend to the store.
Send me a friend request on FB. Joe Sargent

Still looking for help on this workbook