Magnum
03-16-2017, 09:58 AM
Hi all,
I'm looking for how to find the index of a listbox from a value knowing that it has a ListFillRange.
J'ai trouvé comment obtenir la valeur en fonction de l'index :
Evaluate("=INDEX(" & Worksheets(pFeuille).Shapes(pNomListBox).OLEFormat.Object.ListFillRange & "," & Worksheets(pFeuille).Shapes(pNomListBox).OLEFormat.Object.Value & ")")
But I can not do the opposite.
Can you help me ?
_________
Magnum
mickael.pusku.com
I'm looking for how to find the index of a listbox from a value knowing that it has a ListFillRange.
J'ai trouvé comment obtenir la valeur en fonction de l'index :
Evaluate("=INDEX(" & Worksheets(pFeuille).Shapes(pNomListBox).OLEFormat.Object.ListFillRange & "," & Worksheets(pFeuille).Shapes(pNomListBox).OLEFormat.Object.Value & ")")
But I can not do the opposite.
Can you help me ?
_________
Magnum
mickael.pusku.com