checkbox numbers

  • Thread starter Thread starter Ian Coates
  • Start date Start date
I

Ian Coates

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)
 
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)
 
Back
Top