View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Freddie Mac Freddie Mac is offline
external usenet poster
 
Posts: 21
Default Filling TextBoxes

I want to fill several textboxes placed in a userform with the contents of
one textbox. My code is:

Private Sub getInfoFromTextBox1()
userForm1.startDatumTextBox1.text = userForm1.TextBox1.text
userForm1.startDatumTextBox2.text = userForm1.TextBox1.text
userForm1.startDatumTextBox3.text = userForm1.TextBox1.text
.......
End Sub

Now I understand that you can do this in a more efficient manner by looping
it. I got some help but I dont know how to use it (my help function is not
working). The code that I got is:

For each Control in (whatever object you are working with) if Control.name
like "Control*" then
In here I then use Strings.left or Strings.right to sequence my way
through
each of the ending digits. Or I use some other variation on this
theme.
End if

I dont really know how to use it in my case..(i am really bad at VB...).
Please help me out! Would be most greatful!