Where is the TextBox located at... on a UserForm or on a worksheet? If it is on a worksheet, is it an ActiveX TextBox or a Forms TextBox (from the Insert tab/Text panel on the Ribbon)?working on making the fonts in the text box invisible.
could you give a hand ?
Try replacing the highlighted line of code with this...hi , this is my code
If Cells(4, 42) = 1 Then
ActiveSheet.Shapes("scale1").Select
With Selection
Selection.ShapeRange.Line.ForeColor.SchemeColor = 64
Selection.ShapeRange.Line.Visible = msoTrue
End With
ActiveSheet.Shapes("scale1b").Select
With Selection
Selection.ShapeRange.Line.ForeColor.SchemeColor = 64
Selection.ShapeRange.Line.Visible = msoFalse
ActiveSheet.Shapes("num1").Select
With Selection
.ColorIndex = Interior.Color
End With
End If
End Sub
my objective is to make the text in shape num1 invisible.
but error occurs
I don't know... I use XL2010 and the code I posted worked fine for me when I tested it prior to posting it. Maybe one of the properties I used was not available in XL2003... that would explain the error you are reporting.Thanks Rick,
it just highlighted with yellow and no message error show.
try many times.
is it the matter of version ? i use 2003