Posts by Fluff13
-
-
-
You're welcome & thanks for the feedback.
-
In that case add 1 to i in the index
-
-
-
-
I just get the 3 relevant rows from cols A, Q & R
-
-
Line 125 is also a problem. Not sure how to represent the "selected item" of the combo box in the If/Then statement, as .Selected(row) doesn't work the same as for a listbox.
I have no idea what you are trying to do with that portion of the code.
-
Did that piece of code work for you in the example file?
Yes it did, but I forgot to mention that you need to use
-
Not sure how you get an error on line 25 as there is a compile error as soon as you select anything from the combo.
That said you will need to use
Code- 25: vRws = Filter(Application.Transpose(Evaluate(Replace(Replace("if(left(#,7)=""" & q & """,row(#)-~,""X"")", "#", .Columns(37).Address), "~", .Rows(0).row))), "X", False)
- v = Application.Index(.Value2, Application.Transpose(vRws), Array(1, 17, 18)) 'column numbers from RiskDataTable to bring into the combobox
-
In that case can you please supply a sample file.
-
-
You're welcome & thanks for the feedback.
-
Did you try the code I posted? It works for me & I can select one or more cells on a sheet to populate the array.
-
-
Glad you sorted it & thanks for the feedback
-
Can you supply a sample workbook?
-
You're welcome & thanks for the feedback.