View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gab1972 gab1972 is offline
external usenet poster
 
Posts: 57
Default How do i find the text box number?

I'm working on some vba for a friend and between saving, resaving, and
changing, my code busts in the fact that it's looking for Text Box #
and can't find it. My code is looking for TextBox 1 and can't find
it. I know which box it is and I wanted to check to see if the box
number has changed. How do I find that out? Does this make sense?

I tried recording a new macro where I move the box around or edit it,
but MS07 didn't show me the text box # in the recorded macro. Is
there some properties or something I can look at that shows me what
the identifier is of the text box?

Thanks