excel


Excel “true-false” to checked boxes


I have an Excel spreadsheet that I'm generating from a SharePoint dashboard. It's turning my checkboxes in the SharePoint table to "true" or "false" values in the Excel spreadsheet. I wanted to know if it is possible to turn those "true" or "false" values back into checked boxes, with the appropriate check or uncheck option selected.
Any help at all is appreciated!
I strongly advise against using check boxes in Excel if you already have the data as TRUE/FALSE in a cell. Check box controls are meant to be for user forms, and even though they can be placed in the spreadsheet grid, they live in a layer on top of the spreadsheet. Yes, they can be linked to a spreadsheet cell, but this is cumbersome.
Instead of using a macro that inserts a check box for each data row you could use a helper column with a formula along the lines of
=IF([#checkBoxField],"a","r")
Then format the helper column with the Marlett font, which will show the letter "a" as a tick and the letter "r" as a cross.
Applying a formula like this will be much faster than inserting check box controls into each row and linking them to the field cells.
You can add a checkbox over a given cell, then edit its properties (Format Control --> Control Tab) and set its Cell Link property to the address of the cell; i.e. "B2". If you have too many such boolean cells, the task is tedious so you might need to automate it with VBA.
p.s. I agree with #teylyn that this shouldn't be a good choice if you have a huge column of boolean data; it adds too many shapes which is cumbersome. You should use it if the number of boolean cells is rather limited.

Related Links

How to use variable string in index formula in VBA?
Calculate SUM based on date
Need to transpose multiple excel rows to columns [duplicate]
Text to Time with Milliseconds
Exclude rows with formulas from range in macro
Formating excel percentage decimals
Excel VBA - Looking for Strings in “Text Block” , then look in the next
make one cell value 0 if other cell value > 0 using excel
Conditional AGGREGATE/Median in Excel 2010
Excel VBA filtering a column and then copying each item in the area collection to a matching row
Excel addition of multiple numbers in single cell
How do I autofill code in VBA?
Use excel VBA to update master list based on user input data
Change number format of a cell which inlude currecny using visual basic
Access reading Excel VBA date in US format
Changing a file name and path in a formula (within a macro) to user-defined

Categories

HOME
parsing
github
scadalts
hardware
authorization
uwp-xaml
chart.js
imageview
conditional
javacard
google-vr
sorm
corba
row-number
firebreath
postgresql-9.0
pixel
pentaho-spoon
file-permissions
jqxwidgets
autoload
ireport
povray
week-number
byte
modeling
live
direct3d9
leanft
google-tv
pi
fancytree
retrieve-and-rank
singleton-type
cics
orika
tiles
jedi-vim
orders
unicode-string
schemaless
optional
cscope
rpy2
local-variables
parrot
virtual-directory
kmip
timedelta
codeigniter-restserver
ratchet
java-threads
lunrjs
groovy-eclipse
google-roads-api
jquery-widgets
angular-component-router
javascript-globalize
singularitygs
jlist
jaxb2-maven-plugin
android-bundle
zipcode
visual-studio-2010-sp1
slab
searchqueryset
usleep
worklight-server
ntl
mongodb-indexes
stockquotes
resourcedictionary
rounded-corners
struts2-tiles-plugin
jvm-crash
mdbtools
jquery-textext
icefaces-1.8
32feet
launching-application
flotr
spaces
tunneling
bootclasspath
winqual
context-sensitive-help
xml-comments
blat
executequery

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App