Load UserForm ComboBox And Autofill 124 TextBoxes

[Minitman]

Greetings,

I am trying to load a ComboBox on a UserForm with a named range which
has 27 rows and 124 columns. I need to choose a row from the 1st
column of the ComboBox drop down menu. If possible, I would like to
see, as I scroll down, all of the data in the ComboBox change in all
of the TextBoxes as they fill in.

Anyone have any ideas as to how this is done?

Any help would be appreciated.

-Minitman



I have a UserForm with 123 TextBoxes Labeled Input_2 thru Input_
124. I need to fill them from a ComboBox labeled Input_1. The
RowSource for Input_1 is a named range called rInput1 thru rInput31.
the actual named range is determined by a setting when I start

 

[Malik]

Hi,

Not sure that what you are looking? but assume that if you would like to
fillup all your text boxes based on combo box selection then:

You can place your code in any of the 3 events to fillup the text boxes
based on you selection. Ofcourse you need to find the item in the named range
and read correspondent columns to fillup text boxes.

Private Sub ComboBox1_Change()

End Sub

Private Sub ComboBox1_Click()

End Sub

Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

End Sub

If you would like to get some sample code then placed 1-5 columns data here
and I will create some for you.

 

[Minitman]

Hey Malik,

Thanks for the reply.

However, I'm not sure what your code is doing.

I think I'll try ListIndex of the ComboBox Change event and see if
that works.

-Minitman