I have a situation were if a check (tick) box is checked, then a label
has to be displayed on the worksheet with a certain text. If the check
box is unchecked, the label has to disappear. I have managed to display
the label according to my conditions, but every time it appears, the
caption reads "label1" and NOT the text I expect it too. How do I code
the label captioning into my program?
To display the label, this is the code I used.

Private Sub CheckBox6_Click()
ActiveSheet.OLEObjects.Add(ClassType:="Forms.Label.1", Link:=False, _
DisplayAsIcon:=False, Left:=136.5, Top:=72.75, Width:=72,
Height:=18) _
.Select
Range("E8").Select
End Sub

Any help would be appreciated.... thanx