Hi
I have a table in a UserForm consisting of several TextBoxes. All TextBoxes in one column have the same caption and are numbered consecutively from 1 to 12 [ColumnName]Textbox[ROW]. I want to store the values in variables (also numbered from 1 to 12) depending on how many rows are used by the user and started to solve this part with "Loop Until" and arrays:
I have the problem that combining the TextBox caption + j (row number) + ".value" is not recognized as property but as string. How can I solve this and combine these parts correctly?
Many thanks!
Bookmarks