Updating Bound Controls Values automatically
A form having a control text...the control text is getting its value and is bound to a cell in excel worksheet....the cell in the excel worksheet is using COUNTIF formula and taking is value from a range of cells...if any value in this range changes then value in the cell with the formula also changes....
Now going back to the form....the text control value should represent the value of excel worksheet cell containing the formula...
I am facing a problem that the text control is sometime reflecting the changes reflected from the formulated cell when any of the range values are changed...then the response stops and any further changes in the excel worksheet cell bound to the control text are not reflected in the form control text....
I hope my explanation is not confusing....Grateful if you could help..Regards...A. Borhani:)
|