I want to populate a large listbox with 800 items from rows in a worksheet. Can I do that one time in say a global variable, so I don’t have to populate it everytime I run my selection Macro? How would I be able to do that?
How do you create a listbox?
By program (dynamically) or manually (statically)?
If it is a manually created lisbox: You can assign a cell range to the lisbox manually, statically (and you can even change its items programatically - if you want it)
1 Like
Great thnx