Is there any way to renumber checkboxes on a spreadsheet? I have several
spreadsheets each with a large number of checkboxes which have been added
over a period while the sheet was in development. I now find I need to
duplicate these checkboxes elsewhere on the sheet such that when eg
checkbox1 is checked, checkbox83 is also checked. Unfortunately checkbox 2
does not relate to checkbox 84 etc making it a long-winded process to write
the code. It would be a lot easier I could renumber the original checkboxes
so that 1 relates to 83, 2-84, 3-85 etc.

Alternatively, is there a way for a cell to change from being empty to
containing a tick (or X would do), simply by clicking it?

Many thanks in advance

Ian

Ian,

On your alternative, here is a previous post of mine that does that
http://tinyurl.com/2tl6u. Beware, the code is missing an End Sub.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ian Coates" wrote in message
...
Is there any way to renumber checkboxes on a spreadsheet? I have several
spreadsheets each with a large number of checkboxes which have been added
over a period while the sheet was in development. I now find I need to
duplicate these checkboxes elsewhere on the sheet such that when eg
checkbox1 is checked, checkbox83 is also checked. Unfortunately checkbox 2
does not relate to checkbox 84 etc making it a long-winded process to
write
the code. It would be a lot easier I could renumber the original
checkboxes
so that 1 relates to 83, 2-84, 3-85 etc.

Alternatively, is there a way for a cell to change from being empty to
containing a tick (or X would do), simply by clicking it?

Many thanks in advance

Ian

Perfect. Thanks Bob.

Great view you must have there :-)

Ian

"Bob Phillips" wrote in message
...
Ian,

On your alternative, here is a previous post of mine that does that
http://tinyurl.com/2tl6u. Beware, the code is missing an End Sub.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ian Coates" wrote in message
...
Is there any way to renumber checkboxes on a spreadsheet? I have several
spreadsheets each with a large number of checkboxes which have been
added
over a period while the sheet was in development. I now find I need to
duplicate these checkboxes elsewhere on the sheet such that when eg
checkbox1 is checked, checkbox83 is also checked. Unfortunately checkbox
2
does not relate to checkbox 84 etc making it a long-winded process to
write
the code. It would be a lot easier I could renumber the original
checkboxes
so that 1 relates to 83, 2-84, 3-85 etc.

Alternatively, is there a way for a cell to change from being empty to
containing a tick (or X would do), simply by clicking it?

Many thanks in advance

Ian

Not today it isn't, but usually it's lovely.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ian Coates" wrote in message
...
Perfect. Thanks Bob.

Great view you must have there :-)

Ian

"Bob Phillips" wrote in message
...
Ian,

On your alternative, here is a previous post of mine that does that
http://tinyurl.com/2tl6u. Beware, the code is missing an End Sub.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ian Coates" wrote in message
...
Is there any way to renumber checkboxes on a spreadsheet? I have
several
spreadsheets each with a large number of checkboxes which have been
added
over a period while the sheet was in development. I now find I need to
duplicate these checkboxes elsewhere on the sheet such that when eg
checkbox1 is checked, checkbox83 is also checked. Unfortunately
checkbox
2
does not relate to checkbox 84 etc making it a long-winded process to
write
the code. It would be a lot easier I could renumber the original
checkboxes
so that 1 relates to 83, 2-84, 3-85 etc.

Alternatively, is there a way for a cell to change from being empty to
containing a tick (or X would do), simply by clicking it?

Many thanks in advance

Ian