VBA - How to test if a text box is present on the sheet or not?

[Frank Krogh]

I have made a command button on the sheet that shows a text box with help
info.

How do I test if the text box with a given name is already present in the
sheet or not - to avoid creating several instances of the text box?


Frank Krogh

 

[Bob Phillips]

Hi Frank,

Here's some sample code

Dim txt As OLEObject

On Error Resume Next
Set txt = ActiveSheet.OLEObjects("TextBox2")
On Error GoTo 0
If Not txt Is Nothing Then
MsgBox "Already exists"
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)