I'm trying to add to a new sheet, the number related to a list instead of the words showed in the ComboList of a UserForm.
For example, I have a table like this in Excel:
A B (colums)
0 Apple
1 Banana
2 Kiwi
3 Watermelon
The words showed in the ComboList are...