VBA Update to Excel Checkbox

[Tommy]

I am writing an application by VBA with Access. In the
program, I need to get info from Access DB and put into an
Excel file. For normal cells, it's ok to put text in it.
But there are some check boxs on the Excel sheet, how do i
control checkbox value inside VBA code?

Thanks!


Tommy

 

[Cliff Myers]

You control it with a statement like this:
Checkbox1.Value = True
or
Checkbox1.Value = False
Example.... If Cells(1,1) <> "" then Checkbox1.Value = True
HTH