Referring Objects
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 |
Referring Objects
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 |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com