dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,362
- Office Version
- 365
- 2016
- Platform
- Windows
I have a textbox that has the text "Please type notes here" and a button that prints to pdf. If no notes are written in the textbox, a blank text box with the text "Please type notes here" will still appear when I print to pdf. How do I make the text box invisible if it contains the text "Please type notes here"?
This is my attempt
This is my attempt
Code:
Sub NoText()
With ThisWorkbook.Worksheets("NPSS_quote_sheet").Shapes("TestBox1")
If .Value = "Please type notes here" Then
.Visible = "false"
End If
End With
End Sub