Create table within a userform

Hi All,

I was wandering is there a way to create a table within a userform to paste data in it?

Thanks

Thank you for your reply. I thought so but I was hoping to get an intelligent way to what I am willing to do.

Basically I have a spreadsheet with 365 rows and 48 columns of data. I was looking for a way to be able to copy and paste these data into a table within a userform and write some vba codes to do some calculations. there could be few different spreadsheets that the calculations need to be link together so I was hoping something like a userform with an OK button to allow me paste data in it and by pressing OK do the calculations clear the table for the next set of data. I hope I am clear on this.

Originally Posted by 6StringJazzer

There is no built-in "table" control that can be used in a userform. There are ways you can use textboxes to look like a table, but you can't paste an entire table that way. You can only paste one value at a time.

Can you be more specific about what you want this table to look like and what you want to paste into it?

I would use a userform together with a worksheet, instead of trying to simulate a worksheet in the form. A non-modal form could direct the user to a worksheet for pasting data and go back and forth between that and the form. I'll see if I can do a quick mock-up for you.

Thank you very much 6StringJazzer
I really appreciate that

Originally Posted by 6StringJazzer

I would use a userform together with a worksheet, instead of trying to simulate a worksheet in the form. A non-modal form could direct the user to a worksheet for pasting data and go back and forth between that and the form. I'll see if I can do a quick mock-up for you.

Alternatively is it possible to browse a file and get a sum of each row of the source file and paste the value into a destination file? i.e. instead of importing all the values in attached I am looking for a way to browse the file and paste the colum AX (highlighted) into a new spreadsheet.

This is just a demo to illustrate the idea. You haven't given any information about your data organization, worksheets, etc., so I can't give you a solution specific to your problem.

Go to Form1
Select the block of numbers
Click "Open Form"
Click "Paste"

The data will be copied from the current selection, and pasted to the Table sheet

Thanks though,

it is a bit different as the data would be paste from different workbook but it may give me some other ideas as well.

Originally Posted by 6StringJazzer

This is just a demo to illustrate the idea. You haven't given any information about your data organization, worksheets, etc., so I can't give you a solution specific to your problem.

Go to Form1
Select the block of numbers
Click "Open Form"
Click "Paste"

The data will be copied from the current selection, and pasted to the Table sheet