Quote Originally Posted by maryam
I cannot input data directly into the cells of MSFlexGrid or DataGrid Controls:-(.
When you say "directly" do you mean by typing it in when the userform is open, or by code?

I know you can add the data by code into the MSFlexGrid control, I provided a sample of that in post #21.

I think you can add data to the DataGrid control, it's a setting on the control. I don't have the DataGrid control here at work, so I can't directly tell you which one it is. But it's something like "AddNew" and it's default is set to "False" so set it to true and try that out.

Quote Originally Posted by maryam
So I don't get my question. Is there any table like control in which a user can input the data?
Yes, SpreadSheet 11.0/10.0. I am still not sure why you do not want to use that control.

Quote Originally Posted by maryam
My table has fixed number of columns and the spreadsheet doesn't look suitable for it.
You can hide the columns in the Spreadsheet control. Just right-click the control and select "Commands and Options...". Then select the "Sheet" tab and set the "Viewable Range" to be only the columns you want, i.e. "$A:$G" or something like this. And it's much easier to work with in code. It has many members of the Excel.Application object.

I would HIGHLY recommend the Spreadsheet control, it has the most functionality and it would make users feel like they're working with excel...which to me seems more "User friendly/appealing" than the MsFlexGrid or DataGrid controls.