Poor display in listbox

[MARTI MARTI]

Hello Forum
Hello to all
dear members here in this awesome forum I found this attached file below contains a listbox Appointee (choixnom) .. I tried to play with the codes in to solve and understand my problem but finally "I not succeed ".. I want to do 2 things:
1.Where I write the ranking name in columns A .. (marti1, marti2, Marti3, marti4 ... etc)
Also the first names in column B (rose1, rose2, rose3, rose4, rose5 .... etc) and for column C (class1, clase2, class 3, class 4, classe5 ... etc.) ..
sue if I click the button (button1 cmd) that displays the userform .. now I find is unfortunately because in this listbox1
I find the rankings that I do in my data base sheet (BD) has become like that (marti1, marti10, marti100, marti1000 ... etc.) ..
I want my listbox displays the rankings exactly as I am in (BD).

Thank you in advance for helping me to achieve my goal and understand this crazy listbox that will make me really mad ..
Best regards
MARTI MARTI
LISTBOX1.xlsm

[jolivanes]

http://www.excelforum.com/excel-prog...n-listbox.html

[p45cal]

and http://windowssecrets.com/forums/sho...ay-in-listbox?

MARTI MARTI, please have a read of http://www.excelguru.ca/content.php?184 ultimately, it's for your own benefit.

[snb]

On n'a pas besoin de si beaucoup de code.
You will have to diminish the interaction with any worksheet to a minimum.

[MARTI MARTI]

[QUOTE=MARTI MARTI;327238]Hello Forum
Hello to all