Young Grasshopper
Board Regular
- Joined
- Dec 9, 2022
- Messages
- 58
- Office Version
- 365
- 2016
- Platform
- Windows
Hi World!
There is probably a simple solution to this, but i have a listbox that is populate by another textbox. Every time i write something in the textbox and click enter, it goes into the listbox.
But is there a simple way/code i can use, where whenever there is say 10 entries in column 1, then the next 10 goes into the second column, then the third, before 10 new ones in the first column and so on?
Or even better, that the first entry goes to column 1, second entry goes to column 2, third to column 3, fourth to second line in column 1, fifth to second line in column 2 and so on?
So it alternates between three columns (or two columns or whatever).
Would appreciate any help
There is probably a simple solution to this, but i have a listbox that is populate by another textbox. Every time i write something in the textbox and click enter, it goes into the listbox.
But is there a simple way/code i can use, where whenever there is say 10 entries in column 1, then the next 10 goes into the second column, then the third, before 10 new ones in the first column and so on?
Or even better, that the first entry goes to column 1, second entry goes to column 2, third to column 3, fourth to second line in column 1, fifth to second line in column 2 and so on?
So it alternates between three columns (or two columns or whatever).
Would appreciate any help