This Excel VBA List Box example explains, how to create list box in UserForm. How to additem in Listbox, how to transfer data from list box to excel sheet and excel sheet to list box. Watch Advanced UserForm Examples at below link : https://www.youtube.com/watch?v=FnJ5sE0m_hg&list=PLMM5e6ePXVqJ2DaqvASeVqtMVicCQbRs7