ExcelBanter - link checkbox to cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - link checkbox to cell (https://www.excelbanter.com/excel-programming/405090-link-checkbox-cell.html)

pswanie

link checkbox to cell

i got 5 checkboxes and need them to be linked to range a1:a5.

the caption on the checkbox is "report printed" then i need that displayed
in a1, if caption on textbox2 "other" then a1 display "other"

and textbox2 display in range b5

All times are GMT +1. The time now is 12:35 PM.