Export bool Data to Excel as a checkBox

[marlan]

Hi all you experts!

I have an App. that prints out a list from witch people can select (or unselect) list items, using a pen or pencil.... The user then types in this selection.

I would like to automate this process using an Excel sheet, but don't know how to implement the bool value in an excel cell. I think a checkBox would be good.
1) Am I right? there are about 200-700 items in the list.
2) How do I format a cell as a checkBox using acc 2003 VBA?

TIA

 

[Trevor G]

You could look to change the font to a WingDing Character or use a Symbol which gives you a tick

This is the recorded code in Excel to do this

Sub Macro4()
'
' Macro4 Macro
'

'
ActiveCell.FormulaR1C1 = "ü"
With ActiveCell.Characters(Start:=1, Length:=1).Font
.Name = "Wingdings"
.FontStyle = "Regular"
.Size = 11
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
Range("M3").Select
End Sub

Or you could use a Validation with a drop down so the users can select a Yes or No option

 

[DJkarl]

Checkboxes are not a format option in Excel, they are objects, you would need to use automation code and the EMBED function to add checkboxes for each record in your boolean field. If you are an experienced coder this shouldn't take long to setup, if not, then I would suggest recording an Excel macro of you adding a checkbox to see what the VBA code that you need looks like and give it a go, there are plenty of examples on the forum of Excel Automation but if you do get stuck post where you're stuck and the experts should be able to guide you.