Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
VBA Update to Excel Checkbox
1 view
Skip to first unread message
Tommy
Aug 7, 2003, 9:50:40 AM8/7/03
to
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?
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
Aug 7, 2003, 12:59:41 PM8/7/03
to
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
Checkbox1.Value = True
or
Checkbox1.Value = False
Example.... If Cells(1,1) <> "" then Checkbox1.Value = True
HTH
"Tommy" <xil...@rogers.com> wrote in message
news:04f701c35cea$e34999a0$a001...@phx.gbl...
0 new messages