controlsource property problem

[marus_b]

Hello,

I am writing a program in VBA which is based on forms with a variety of textboxes, command buttons, and other controls. I have used the controlsrouce property, programatically, to establish a two way relationship between an individual cell and an individual textbox on my form. It worked just fine for a while, and then all of the sudden it stopped working. Basically the value in the cell is still updated if I enter new text in my textbox. But, for instance, if I clear/change the contents of that cell, the value of the textbox will not be updated. Therefore it seems that now the relationship is working only one way. Did anybody ever encounter such problem? Is there anything that I'm missing here?


Thank you in advance for any suggestions.

 

[marus_b]

Solved my problem. Hopefully this will help someone else in the future. I have run a "repair" feature on my Microsoft Office Professional 2007 bundle, and it did a trick. Now the controlsource property is working like a charm. And yes, I did have the Service Pack 1 installed. Interesting, unexpected and still not clear why would something like this happen, but at least it's back to normal (for now!).