Userform Datagrid or anything better?

[calvinle]

Hi,

If anyone know access, is there anything comparable to ms access subform in Userform Excel? I need to enter data to the spreadsheet, but entering via textbox and click every time take forever. I wonder if there is any way that I can enter all in "subform" way and click to submit one time all the data.

With subform, you only need 1 object, but if I have to do the same, I will need to add several textboix?

Anyone have idea?

Thanks.

[millz]

Check out the suggested spreadsheet control in this thread.

[calvinle]

But what is I distribute the excel file to another computer that does not have that component? Will it still work?