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

select data of one column on basis on another column in excel
In a multi-sheet workbook, how do I code a multi-column sort in VBA?
How to merge multiple workbooks into one based on workbooks names
Changing range in a lookup formula based upon a value
VBA error on “Loop Until” statement
Possible to use QUARTILE function over a conditional range in Excel? [closed]
How to transpose the value in excel based on condition?
“Cannot insert object” Error when inserting PDF files/objects into Microsoft Excel
Referencing the selection in deactivated Workbook
Excel - Export cells identified by countif to new file
Attempting to search for strings and having syntax errors
Excel Error 1004 when referencing ranges with VBA
Multiple uses of SaveAs freeze Excel
XYScatter Plot Incorrect XAxis when Drawn in Visual Basic?
Why is “if isna vlookup” quicker than “countif”?
PrintLoop mass print all rows of data in file

Categories

HOME
objective-c
web
graphite
iframe
asp-classic
get
javafx-2
houndify
timezone
wayland
android-gradle
delay
openmeetings
jestjs
delaunay
axon
pixel
systemml
jquery-animate
cider
sitefinity
apache-felix
unimrcp
cut
powerpoint-vba
scons
edi
vowpalwabbit
polymer-starter-kit
ipc
induction
appery.io
tail-recursion
tridion
ngrx-effects
dataweave
webos
multibox
autocorrect
pwd
exports-loader
inputstreamreader
invoke
shared-ptr
dependency-properties
fixed
windows-firewall-api
gm
strstream
apple-watch-complication
qtquick2
oslo
cts
mime-mail
splash-screen
frontpage
togglz
stunnel
traffic-simulation
assignment-operator
fswatch
glut
order-of-operations
gamma-function
google-client
allocation
srv
slab
fad
ember-qunit
sqr
facade
sharepoint-clientobject
code-metrics
textile
impactjs
rails-i18n
factoring
freetextbox
avassetwriter
resourcedictionary
texmacs
contactscontract
graphml
icommand
amber-smalltalk
customvalidator
wexitstatus
visual-studio-test-runner
clang-complete
nsinteger
sqa
soaplite
tunneling
ant4eclipse
zend-navigation
executequery
open-basedir

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