SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,126
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi, hope all is well.
I haven't really used list boxes before.
But i have one in a user form, and i want to use it to control adding and displaying notes.
I can easily add an item to the list box like below.
But my notes will be in the wrong order, i would like the newest entry to be on top listindex 1 or 0
i just cannot figure out the code to make this happen?
thanks
dave
I haven't really used list boxes before.
But i have one in a user form, and i want to use it to control adding and displaying notes.
I can easily add an item to the list box like below.
But my notes will be in the wrong order, i would like the newest entry to be on top listindex 1 or 0
i just cannot figure out the code to make this happen?
thanks
dave
VBA Code:
A = InputBox("ENTER A NOTE", "")
If A = "" Then Exit Sub
Me.LB1.AddItem A