I have a project where various items from many different 'sub-classes' are very widely separated/distributed on a msXL worksheet.
To make this project user-friendly, using 'additional controls' I have embedded cells (from another worksheet program - viz: "easyoffice") onto a userform. The idea being that the user can view and input new data for any particular sub-class in a very simple summarized form without having to search through the entire worksheet for the correct column etc.
This raw data on the embedded cells then has some initial calculations performed on it, the results are then double-checked by the person inputting the data, and if there are no corrections required, the data can then be written onto the XL worksheet in the relevant columns.
Not everyone can be expected to have these two different spreadsheet programs on their computer so this solution is not going to be much use to friends who want to use my project for themselves. I really need to embed some EXCEL cells, but cant find any reference to such a procedure.
My question is this: How do you embed some XL worksheet cells onto a userform that is to be displayed over the top of the main XL worksheet?