Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load & Access a UserForm ComboBox
Greetings,
I have a range of cells that is 27 rows tall and 105 columns wide. Column C has the information that needs to appear in the ComboBox on the UserForm. At this time, it is the information in Column D that is showing up. Here is the code that loads the ComboBox called I_3: __________________________________________________ ________________ Public Sub Load_I3_List() ws1_2.Activate 'Sheet with the named range on it Set rListInput = _ ws1_2.Range("rInput" & iTD) 'The named range With I_3 'the ComboBox .RowSource = "'Input'!" & rListInput.Address .ColumnCount = rListInput.Columns.Count .ListIndex = 0 End With I_3.Value = I_3.ListIndex + 1 End Sub __________________________________________________ ________________ I am not sure how much of rInput1 (with iTD = 1) is actually loading. I need to have the code enter the rest of the row into the rest of the 104 TextBoxes called I_1 thru I_105 (minus I_3). They correspond to the columns on the sheet where column A = 0, B=1, C=3 etc. Column C is the column with the reference name used elsewhere. If this question is to vague, I will gladly answer any questions that might arise. Does anyone have any ideas as to how to do this? Any help would be greatly appreciated. -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a Combobox in a Userform access multiple dynamic tables | Excel Discussion (Misc queries) | |||
Load UserForm ComboBox And Autofill 124 TextBoxes | Excel Programming | |||
How Do I Load a ComboBox From a Dynamic Range | Excel Discussion (Misc queries) | |||
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 |