View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Plum Plum is offline
external usenet poster
 
Posts: 29
Default A quick way to edit the formula in check boxes

Hi there,
I have got a massive number of check boxes which all need to be linked to a
cell. I know you can do this by clicking on each box individually, but I
wondered if anyone knows a quick way of editing the formulas behind the boxes
en masse.
If it were an ordinary formula, find and replace would do the trick but this
doesn't work for check boxes.
Thanks.