PDA

View Full Version : Poor display in listbox



MARTI MARTI
06-28-2015, 07:24 AM
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
13810

jolivanes
06-28-2015, 09:53 PM
http://www.excelforum.com/excel-programming-vba-macros/1090772-poor-display-in-listbox.html

p45cal
06-29-2015, 03:32 AM
and http://windowssecrets.com/forums/showthread.php/169687-Poor-display-in-listbox?

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

snb
06-29-2015, 04:13 AM
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
06-29-2015, 04:27 AM
[QUOTE=MARTI MARTI;327238]Hello Forum
Hello to all