Hello everyone!
I am attempting to automatically set the value of three active x scroll bars to 0 if a calculated cell's value changes.
Given the calculate event can't have a range specified I am linking my calculated cell to a text box "TextBox1." I am then using the code below to theoretically detect the change and set all three scroll bars to 0 (Bars are named bbbar, ecbar, and ccbar)
Can anyone help me figure out why this is not working?
I have tried creating a active X textbox that is linked to the calculated value and then using this code to detect a change in the calculation but it is not working.
Any ideas? I truly appreciate the help.
Bookmarks