B
BRG
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.
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.