Thread: tick box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rexmann rexmann is offline
external usenet poster
 
Posts: 79
Default tick box

Nice one thank you

"Andy B" wrote:

Hi

Depending on exactly what you want you could use the spinner control from
the Forms toolbar. This can be linked to a cell with an 'up' click adding
one to the cell and a 'down' click subtracting one from it.

--
Andy.


"rexmann" wrote in message
...
Hi all

Does anyone know a formula or script that creates a tick box so when you

click on the cell it adds a result. I have lots of data to collate from
questionnaires - it only has to be a yes or no type response (or a 1 or
null).

kind regards

Rexmann