Add a Spreadsheet to a VB Form

[Dan]

All,

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

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

Any ideas?

 

[Nacho Nachev]

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

 

[Tom Ogilvy]

Put a multicolumn listbox on the form and assign its rowsource to
sheet1!A110