VBA Update to Excel Checkbox

  • Thread starter Thread starter Tommy
  • Start date Start date
T

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
 
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
 
Back
Top