Reputation: 47
New to vba. I am Trying to Make a vba textbox border invisible but the BorderStyle function is not doing anything. Attached below is a picture of the box.
Here is the code, it's very straightforward:
Private Sub TextBox1_Change()
TextBox1.MultiLine = True
TextBox1.Font.Size = 9
TextBox1.BorderStyle = 0
End Sub
Upvotes: 0
Views: 502
Reputation: 49998
Just to close this question out:
No need to do this with VBA. You can change the border style manually in the VBA Editor.
Toggle the BorderStyle to 1 - fmBorderStyleSingle
and then back to 0 - fmBorderStyleNone
.
Upvotes: 1