Clearing text box and activex text box contents

Hi,

I am new to Excel VBA and I am trying to clear the contents of a worksheet that contains both normal and activeX text boxes.
I tried the following but it doesn't seem to work. Any guidance would be really appreciated.

Sub TextBoxClear()
Dim wks As Worksheet, tb As TextBox
For Each wks In ActiveWorkbook.Worksheets
For Each tb In wks.TextBoxes
tb.Text = " "
next wks
End Sub

Many Thanks,
Zoe

Hi Zoe

I like names with Z's in them.
Try this..

Please Login or Register  to view this content.

You'll see that you need a 'Next' for every 'For' etc etc etc

zeddy

Hi Zoe

I also meant to say welcome to the Forum.

..and watch out for the Forum police that want you to post your sample code between proper code tags.

zeddy

Hi Zoe

..and joining this Forum on the Queen's birthday too!

zeddy

Hi Zeddy,

That works great thank you. And thanks for the posting advice. Didn't realise I had joined on the Queen's birthday!
Hope you are keeping safe and well.

Thanks,
Zoe