Tick Box

[CraigFowler]

I am trying to create a spreadsheet to track my drawings that i issue t
clients. I am using Excel to create a data list on one worksheet.
would like to have a column in which i can highlight a cell to produc
a tick. I would then pick a macro button to create a new workshee
with those picked lines shown. This will then become my issue email.

Is there an easy way producing a tickbox in a cell?

Grateful for any help !

Thanx
Craig :

 

[Frank Kabel]

Hi
no easy solution. You could use an event procedure (selectionchange) to
create such tick box. See:
http://www.cpearson.com/excel/events.htm