a Clickable check box

shaftdx

New Member
Joined
Aug 20, 2018
Messages
49
I was just going over some old files on our server trying to look busy at work, I came across one that had clickable check mark boxes, I have NO idea how that is done! I did not even know that was possible! can anyone help me with how to do that? I can use that function on a few other of my spreadsheets. and is there away that if you do check it something else will happen, like a row boing highlighted or something?
 
Last edited:

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Candyman8019

Board Regular
Joined
Dec 2, 2020
Messages
138
Office Version
  1. 365
Platform
  1. Windows
In your Developer menu there will be an insert item on the ribbon bar. You can use that to draw a checkbox. Use the properties window to adjust properties as you see fit and you can use the .value property (true or false) to affect other functionality.
 
Solution

shaftdx

New Member
Joined
Aug 20, 2018
Messages
49
In your Developer menu there will be an insert item on the ribbon bar. You can use that to draw a checkbox. Use the properties window to adjust properties as you see fit and you can use the .value property (true or false) to affect other functionality.
Took awhile to figure out how to add in the developer on the ribbon but I got it now and will experiment with it. Thank You!
 

Watch MrExcel Video

Forum statistics

Threads
1,127,822
Messages
5,627,096
Members
416,220
Latest member
Sykotik7S

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
Top