I have two sheets. In the first sheet, all the data is input by the user. The code takes data from sheet1 and does things in sheet2.

Is it possible to make a userform in sheet1 that displays a table of cells from sheet two. The idea would be to modify the cells located in sheet2 through the userform which is displayed in sheet1. I would like to display the cells in the userform just as they would appear in sheet two (size, color, formatting etc.)

Is this possible with the available controlls on the userform?

schwizer