i have
1) a sql server table
country code country name
1 india
2 usa
3 japan

2)Listbox lstCountry on a form 3) excel sheet cell()

i wana
1) display all country name in list box (I have done it by recordset,additem)
My Problem -->2)when country name selected in listbox ,corresponding
country code insert in excel sheet cell (i can use itemdata property but how)
any code or advice
PLZ help me i m coding on VBA