I have a simple problem. Unfortunatley I don't know the solution.

I want to have the text shown in the text box change based on the value
defined from a Spinbox.

The value from the spinbox should drive the number of a Row that the
text is sourced from on a different page. The column reference will
aways be fixed.

So, simply put: A value of 1 from the spinbox should have the textbox
populate with the text from A1 on another sheet. A value of 2 from the
Spinbox would populate the text box with the text from A2 on the other
sheet.

I am pulling my hair out trying different things to do this, but
nothing works yet.

Robert