Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding test and cell address to combo box.
ok, I have this code below that populates ComboBox3 with the text in MyRange.
What I would like to do is record the address of the cell somwhere for reference once a value is selected in combobox3. EX. If ComboBox3 is populated and I select the text that is on cell K1 I need the address K1 recoreded somewhere so that I can populate a second combo box with range k3:k18. Or if the text for L2 is selected I need a second combo box with L3:L18 and so forth. ========================================== Dim MyRange As Range Set MyRange = Sheets("sheet1").Range("k1:z1,k21:z21") For Each C In MyRange If C = "" Then GoTo 10 Else ComboBox3.AddItem C.Value End If 10: Next ========================================== |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo function of adding % | Excel Worksheet Functions | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Converting test to numbers and adding into a summary page | Excel Worksheet Functions | |||
Adding Sheets to a combo Box | Excel Programming | |||
adding info to combo box | Excel Programming |