Hello all,

I am trying to color an textbox in an image using VBA. The second sheet has the cell on which the textbox color
will be based on. For instance, if the cell has a value 1 then color the textbox in the image as yellow otherwise
if its zero then color it black. I can make a VBA code for it, but the problem is I will have to run the code each time.
On the image I have a scroll bar attached, which will change the value of that cell on the second sheet.
So what I want is as press the scroll bar on the image, the textbox color changes as the scroll change will change the value in the cell on the second sheet. So thousand i press the scroll bar down, thousand times the color of the textbox changes
workbook event ? I tried activate but same thing I have to change the sheet and back again to the effects.

Thanks