View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren Hill[_3_] Darren Hill[_3_] is offline
external usenet poster
 
Posts: 68
Default Rename Textbox on Worksheets

I have several worksheets each of which have 4 identical textboxes.

I'd like to rename each of the textboxes (say, TB1, TB2, TB3, TB4) so I
can create code for all the sheets and not have to work with the unique
names each box has at present.
How do I do this, or is there a better way to access the textboxes (say,
by their underlying cell refs)?

Thanks in advance.
--
Darren