Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check Boxes or Option Buttons | Excel Discussion (Misc queries) | |||
option buttons or check boxes | New Users to Excel | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Check Boxes / Option Buttons.... | Excel Programming | |||
Check Boxes and Option Buttons | Excel Programming |