View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim G Jim G is offline
external usenet poster
 
Posts: 132
Default Test for text boxes

I want to test for a text box ("text box 2"). If it exists delete it if not
do nothing.

I can delete the text box with 'Worksheets("Expense").TextBoxes("textbox
2").Delete' before I print the sheet. However, if the worksheet is reprinted
it comes up with an error because it can't find the text box.

Any suggestions appreciated.
--
Jim