View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default How To Use The Number Part Of A TextBox Name As A Variable

How is TextBox99 currently being called?

Tim





"Minitman" wrote in message
...
Greetings,

I have several TextBoxes numbered 1 thru 200. The code in each of
these TextBoxes is the same except for a reference to the TextBox
number.

Example:

Private Sub TextBox99()
Call MySub 99
End Sub

Is there anyway to replace the figure "99" with some code that gets
that number from the sub name?

Any help would be appreciated.

-Minitman