Solved: Excel 2011 - can not update locked textbox programmatically if locked

[mikerickson]

BTW, found your datepicker; very nice!

Where did you find it? Do you still have the link?

In the attached, clicking on the seperate labels "8am","noon", etc. will adjust the time accordingly.

One of my pet peeves is the use of If..Then..Else to set boolean values. I altered the CheckBox1_Click event.
[VBA]Private Sub CheckBox1_Click()
With TextBox1
.Locked = Not (.Locked)
.Text = Format(ScrollBar1.Value / ScrollBar1.Max, formatString)
End With
End Sub[/VBA]