Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My VBA program will require multiple dynamic arrays of
strings. These will be "parallel arrays", meaning the arrays will be the same size, and the indexes of each array will be related to the corresponding indexes of the other arrays. So....I decided that I do NOT want to bother using dynamic arrays for my program, simply because dynamic arrays are a pain to manage, and other reasons related to the design of my program. Instead, I was thinking about creating a few hidden Listbox controls on a Userform (i.e Visible = False). Then, I could simply use Listbox.AddItem() to continually add new strings to the various hidden Listbox's, and possibly remove or search for strings if necessary. I'm just curious, but has anybody ever implemented something like this in their VBA program? How did it work for you? Were there any problems that I should know about? What does everybody else think about this idea? I'd appreciate any comments. Thank you. Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DYNAMIC LISTBOX | Excel Programming | |||
Speed of fixed array versus dynamic array | Excel Programming | |||
Dynamic Array Lbound not working when only one value in array | Excel Programming | |||
dynamic fill of listbox - need help | Excel Programming | |||
Dynamic Multi Column ListBox | Excel Programming |