I am trying to educate myself on creating static multi-dimensional arrays via VBA.
Please bare with me as my knowledge of this topic is very limited.
Question:
Dim [variable name]([first] To [last] ) As [Type]
With an excel userform, I want to create the [variable name] from a textbox within the userform. (text in textbox1 would be the name of the array)
Also, using combo boxes, I want to make the [first] To [last] values. (ComboBox1 would be [first], combobox2 would be [last])
I would appreciate any information on the topic.
I have done some research however, I do not have a good understanding yet on arrays.
Thanks!