sheet1.CheckBox1.Value

where Sheet1 is the codename of the sheet with the checkbox or

Worksheets("Sheet1").Checkbox1.value

where Sheet1 is the tab name of the sheet with the checkbox.

This is for a checkbox from the control toolbox toolbar.

for a checkbox from the forms toolbar

If Worksheets("sheet1").Checkboxes("Check Box 1").Value = xlOn then

--
Regards,
Tom Ogilvy



"Squid" wrote in message
news:PNVkd.601909$8_6.422495@attbi_s04...
I have a checkbox on sheet1, which I plan to give the user an option to
whether or not to hide some columns beforePrint. How to I refer this
checkbox object to be used in the Workbook_BeforePrint event?

TIA
Mike