User form memory

[JeremyA1976]

I am trying to write a code so that the last input is saved in each of the text boxes in the user form in the most recent submission. I want it to recall the current price on an item, so it can be compared and changed if needed. It is rare that we change prices on all items, but there is always crazy ups and downs on certain items. The items all have cells in worksheets that i can recall or compare to, but im not sure on the language.

 

[ranman256]

write all cells to a temp sheet for holding the values.

'write all textboxes to the normal place
sheets("sheet2").range("A1") = txtBox1
sheets("sheet2").range("A2") = txtBox2
etc

'write all textboxes to the last used sheet
sheets("sheet3").range("A1") = txtBox1
sheets("sheet3").range("A2") = txtBox2
etc