Text madness, Spinbox and Textbox?
 

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

Text madness, Spinbox and Textbox?
 

Hi Robert

Formula solution
=OFFSET(Sheet4!A1,A1,0)
Where Sheet4 is "the other sheet" and A1 contains the spinbutton value.

HTH. Best wishes Harald

skrev i melding
oups.com...
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

Text madness, Spinbox and Textbox?
 

Great! You read my mind perfectly. I (before trying a text box
solution) was trying the same thing but I was using the wrong worksheet
command. I had some silly thing like this (of course it didn't work).
Thanks!

=Sheet1!("$A" & A1)

Where A1 was the linked cell with in integer from the Spinbox.

*SIGH*

Robert