Load UserForm ComboBox And Autofill 124 TextBoxes
 

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

Load UserForm ComboBox And Autofill 124 TextBoxes
 

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.
--
Malik


"Minitman" wrote:

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

Load UserForm ComboBox And Autofill 124 TextBoxes
 

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

On Thu, 1 May 2008 00:32:10 -0700, Malik
wrote:

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.