View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default Display of control check boxes and option buttons

I have seen this problem but so long ago I'm not sure what the solution was.
I'd guess it's to set the value of the control directly:

Sheet1.CheckBoxes("Check box 1").Value = True

This is for a Forms toolbar check box. You didn't mention which kind you're
using.

--
Jim
"BRG" wrote in message
...
I am having a problem with the display of control check boxes and option
buttons reflecting the value of their linked cells.

I have a VB macro that goes in and changes the value of the cells that
controls are linked to. When the value has been changed, some controls
(usually the ones in the first couple of rows on the sheet) will update
their
display to reflect the (new) value of their linked cell, while the rest
retain the display they had before the change.

Any ideas on what could cause this? Do I need (or is it possible) to tell
the control objects to update their displays to reflect the value of their
cells?

In case this has some bearing, I turn ScreenUpdating off before the
copy/paste and back on again afterwards, and I use
Worksheets().Range().FormulaR1C1 = Worksheets().Range().FormulaR1C1 for
the
copy/paste.

--
BRG