Creating Table in form in excel

[Guest_imported]

Hihi, how to create table in userform for excel?? the user is able to enter the datas, edit the datas and update the datas in the table to the excel spreadsheet.

thank you!

 

[euskadi]

I have a 3 part answer:

1) I don't know.

2) If I were to do this, I'd create a separate spreadsheet in the workbook where I had carefully controlled the look and layout of the spreadsheet so it looks and feels like a form.

3) And now that I think a bit more, I did once throw a small 3x5 range of text boxes packed tightly together so that they looked like a table. I only did that because the rest of my project was form based, the project really had little to do with Excel.

 

[dsb]

(#2 is a good point). Use spreadsheets for table entry. The user already knows how to use this interface.

Do anything else from rolling your own or using a table-control and the user will have to learn some new rules and you may have to write more code than want to maintain.