CODEWITHSUNDEEP
vbaexcel
Kunal
Kunal

Reputation: 63

Insert a spreadsheet in a form VB

I am trying to insert a spreadsheet like functionality in a form where user can copy a subset data from one spreadhseet and paste it in the spreadsheet in the form. I tried creating a datasheet form but I am unable to add anything to it. I also tried creating bunch of text boxes for representing columns but in this case I can only paste one row from spreadhseet to this form.

Any help or pointer will be of great help.

Upvotes: 0

Views: 94

Answers (3)

Kunal
Kunal

Reputation: 63

I got it working using datasheet bound to a table. thanks for the help guys.

Upvotes: 0

Sam
Sam

Reputation: 948

You could use a List box, however you will need to set the columns and the user will have to make sure they select only that amount of columns. Then have a paste button in the form which will take the clipboard and add it to the list box.

Upvotes: 0

Mike Stratton
Mike Stratton

Reputation: 475

Create a class that allows the user to upload a file (spreadsheet that has been saved in a .csv format) and then use the TextFieldParser object to read the file.

Upvotes: 1

Related Questions