Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Individual values from a Combobox List placed in textboxes | Excel Programming | |||
Filling Textboxes from Combobox selection | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
How Do I Load A ComboBox On A UserForm | Excel Programming | |||
searching for a combobox.value and filling in textboxes from results | Excel Programming |