frame question in a user form

[alann2]

Hello all,
I have a user form for course feedback, which populates a spreadsheet. if I have a frame on a multipage control can I import a range of cells from the spreadsheet so that I can put scores into the cells to update the spreadsheet?

any help would be fantastic.

Alan.

[colofnature]

You don't need to worry about which frame or page contains a textbox (or whatever you want to read the value of the cells into. If you have a form with a multipage, a page of which contains a frame, which in turn contains TextBox1, you can read a cell value into it simply using

TextBox1.Value = Range("A1").Value


Col

[alann2]

Fair one, however.
within the information that I want to display in the form is a list of questions then a list of results that may be partially complete, when the userform is filled in the results need to be updated on the sheet.

i.e

trainer feedback 4 3 2 1 (the column headers)
pace 16 3
punctuality 20 0 0 0 (the results

is there a way that I can import onto the user form the header cells and the question cells, also the partially completed results cells? So that I can then complete the results and when the form is submitted back to the sheet the results are added to the original cell values?

Alan.

[colofnature]

See attached

Col

[alann2]

thank you thank you thank you.

Alan.