Add a Spreadsheet to a VB Form
 

All,

I am attempting to add a portion of an excel spreadsheet
to a VB Form.

Lets say that I have a range from A1:D10 on Sheet1. I
would want that portion of the sheet to appear on the
Form.

Any ideas?

Add a Spreadsheet to a VB Form
 

Speaking theoretically, you may add grid control to your form and
import/export the data through code. I don't know if it's possible to embed
the spreadsheet as control on a form or probably this will be quite an
effort. There are some good grid ActiveX control available, but I've not
done this for years, so prefer not ro speak more.

HTH,
Nacho




"Dan" wrote in message
...
All,

I am attempting to add a portion of an excel spreadsheet
to a VB Form.

Lets say that I have a range from A1:D10 on Sheet1. I
would want that portion of the sheet to appear on the
Form.

Any ideas?

Add a Spreadsheet to a VB Form
 

Put a multicolumn listbox on the form and assign its rowsource to
sheet1!A1:D10

--
Regards,
Tom Ogilvy

"Dan" wrote in message
...
All,

I am attempting to add a portion of an excel spreadsheet
to a VB Form.

Lets say that I have a range from A1:D10 on Sheet1. I
would want that portion of the sheet to appear on the
Form.

Any ideas?