Check Box help

angleyez423

New Member
Joined
Dec 3, 2005
Messages
5
I am making a spreadsheet to track club dues. I want a checkbox that when it is checked it will link to another cell with the amount owed for that day. For example: I created a checkbox, when it is clicked, I want the number 1 to show in cell C3. I am able to create the box using the forms toolbar, but all I can get the link to say is True when checked and False when unchecked. I don't want to see that info.

Thanks for the help.
Jillian
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Welcome. Try something like this:

Press Alt-F11 to bring up VBA
In the left pane, double-click the sheet to attach this to
In the right pane, paste this in:

Private Sub Worksheet_Calculate()
If [c3] = "FALSE" Then
[c3] = 0
Else
[c3] = 1
End If
End Sub

Assuming that you have calculation on auto, it will work for you.
 
Upvote 0
It does not open 2 panes. I got the VBA itself open with 1 pane, I input the code in the one pane that opens and it stays in there, but has no affect on the spreadsheet. Nothing changes. I must be doing something wrong.

Thank you
 
Upvote 0
Try this:

Alt+F11 and View - Project Explorer. Then follow tactps steps. You must have gotten the codes in wrong place.

Edit: Make sure you remove the codes from where you pasted them in the first place.

Hope This Helps

RAM
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top