i Am new at VBA and i have a basic understanding.
I am trying to find out if it is possible to write code that would reffer to a given lcoation and store the file names in that location into an array.
i am planning on using the names in the array to populate a combo box. and then use the selected file name in the combobox (which would be a picture) to change the back ground of a form.
i can do the background part, thats easy.What i dont know how to do or if it could be done is to get the file names and store them into an array and then populate the combobox.
im not sure if arrays have to be defined in size that may be an issue because the number of pictures in the file would or could change.
all inupt would be greatly appreaceated
and please dont hate me for programming something so superficial
I am trying to find out if it is possible to write code that would reffer to a given lcoation and store the file names in that location into an array.
i am planning on using the names in the array to populate a combo box. and then use the selected file name in the combobox (which would be a picture) to change the back ground of a form.
i can do the background part, thats easy.What i dont know how to do or if it could be done is to get the file names and store them into an array and then populate the combobox.
im not sure if arrays have to be defined in size that may be an issue because the number of pictures in the file would or could change.
all inupt would be greatly appreaceated
and please dont hate me for programming something so superficial