Dear experts,

I am very new to VBA and GUI creation. Please excuse me if it is a trivial question.

I need to insert a table in an userform for automating an engineering calculation. Supposedly there was an option in "additional controls" for inserting "microsoft office spreadsheet" in previous versions of excel and this feature has been removed in the latest excels.

1. Now, how do I insert such a table in the lastest version? Please find attached the jpeg. When the user inputs the number of bolts in the space provided, say 25 bolts, I would like a 25 X 6 table to appear below it. In this I would want the 2nd and 3rd coloumn as a dropdown (2nd coloumn for direction of bolt with options +x, -x, +y, -y, +z and -z; 3rd coloumn coloumn with dropdown 1,2 and 3). Coloumns 1,4, 5, and 6 will be filled by the user.

2. Once the table is filled by the user, I will put it in one more command button at the bottom, which, when clicked, should save the table as a "tab seperated value" file. Is this possbile?

Can you please let me know how I can achieve these or point me to a relevant source which will help to me achieve this?


Thanks.
userform_example.jpg