Hi,

How can I define a column in a worksheet so all its items will be check
boxes.Meaninig, every record in this worksheet , at this column will have a
check box.

Thanks

David

Check boxes are not restricted to columns (or even rows) They appear in a
different layer of the sheet. What were you thinking of doing with all of
these checkboxes, there may be a workaround?

"DavidE" wrote:

Hi,

How can I define a column in a worksheet so all its items will be check
boxes.Meaninig, every record in this worksheet , at this column will have a
check box.

Thanks

David

Just jumping in here, because I've wanted to do something similar. Think of
a punchlist or a to-do list, with a boolean "yes, it's done", or "no it
isn't."

On a construction project of any size, various contractors and
subcontractors work off of a sheet printed and taped to a wall for each
area, which includes the work to be done. They check off work as it gets
complete. Surprisingly, many large jobs generate these sheets via Word,
which leads to a tracking nightmare. Tracking such info and generating
punchlists in Access is probably best, but for a small job, excel could be a
nice tool for doing this.

"bigwheel" wrote in message
...
Check boxes are not restricted to columns (or even rows) They appear in a
different layer of the sheet. What were you thinking of doing with all of
these checkboxes, there may be a workaround?

"DavidE" wrote:

Hi,

How can I define a column in a worksheet so all its items will be check
boxes.Meaninig, every record in this worksheet , at this column will have
a
check box.

Thanks

David