List box add item of a range Horizontaly not vertically

[HaroonSid]

hi,
in listbox
when items goes more then the Size of listbox we get a scroll bar to down or up to see the added items

i want to add item Horizontaly
i mean i want to scroll listbox Horizontaly not vertically

thank you

[xlnitwit]

If you only have one column and it's too narrow, you can increase the columnwidths property. If you have more than one column the listbox should provide a scrollbar automatically unless you turned it off.

[HaroonSid]

yes i have only column in my listbox

[HaroonSid]

like this
2nd imaga when i add more data it create a scroll bar
2.JPG
3 i want like this when i add more data then size of listbox

1..JPG

[xlnitwit]

Then you'll need to figure out how many rows your listbox can fit based on its Font size, add columns as necessary, then populate it.