Linking Text to a Spinner

[SonicBoomGolf]

I want to link a number entered in the middle of text to a spinner value. As the spinner values changes, I would like for the number in the text cell to change also.

The text is entered in the cell as such:
Under the current assumption, 1% of all customers will purchase a lesson plan.

I am including spinners so that my potential clients can create their own "What-If" situations. So if the 1% was change to a 5% due to clicking the spinner, I would like the cell containing text to now read:

Under the current assumption, 5% of all customers will purchase a lesson plan.

Any Ideas?

 

[BJungheim]

Are you storing the value of the spinner in a seperate Cell? If you are, you can use the following formula:

="Under the current assumption, " & F8 & "% of all customers will purchase a lesson plan."

Where F8 holds the spinner value in this case.

Otherwise, use the following code:

Private Sub SpinButton1_Change()
    [A1] = "Under the current assumption, " & SpinButton1.Value & "% of all customers will purchase a lesson plan."
End Sub

 

[SonicBoomGolf]

Thanks for the help. Your tip, ="Under the current assumption, " & F8 & "% of all customers will purchase a lesson plan." worked perfectly. Thanks.