Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Textboxes | Excel Programming | |||
filling userform textboxes | Excel Programming | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
Filling Cells from Textboxes | Excel Programming | |||
searching for a combobox.value and filling in textboxes from results | Excel Programming |