Printable View
okay well i have information that a user enters into a textbox. this information then gets placed into an array. i want the user to be able to search with this information and i want the user to view the file which will be saved as a text file. is there any way i can connect the arrays and make then easy to access later with a search?
The start to the answer to your question is here.
i do not understand the question
i want to enter information on a group of members but the thing is i dont know how big it will be. so i want to use a seperate array for all the bits of information i will collect like address and then connect them together. is there any way or pairing or connecting all of these seperate arrays?
maybe you should look at a UDT (user defined type), which can hold all the information in each element
do a search on declaring and using UDT
isnt that more a VB thing then a VBA thing? i looked it up but i found it on a VB site? and it says it cant be used within a procedure? either way is it the same thing as a multi-dimensional array?
similar to a multidimentional array, but more convenient to use,
i believe a UDT can be used in VBA, you have to declare it in the general section of the module, not within a proceedure, but then you can use it within any proceedures, depending on the scope you declare it (public or private)