I have a spreadsheet using userforms. On the userform,
there are several spinbuttons linked to a textboxs. The
textboxs are formatted to show the values as either
percentages or dollar values. When the user presses the
spinbutton, the values change in the textbox which
adjusts a calculation that takes place in the
spreadsheet. The results of that change appear in a list
box that is located on the same userform. The way it is
working now, the spinbutton value change does not change
the results calculation shown in the list box until the
form is closed and reopened or different spinbutton is
depressed. Controlsource of the spinbutton is set to a
cell on the spreadsheet, which changes each time the
spinbutton is depressed. Now I just want the spreadsheet
to calculate and display the results immediately in the
associated list box. I am a programming rookie, so a
simple explanation on why it isnt happening, and what I
need to do to make it work would be greatly appreciated.

Below is an example of the code from one of the spin
buttons.

Private Sub SpinButton7_change()

Me.TextBox8.Text = Format(Me.SpinButton7.Value /
100, "##,##0%")
Me.TextBox12.Value = Format((((Me.SpinButton7.Value /
100) * 0.6) + ((Me.SpinButton8.Value _
/ 100) * 0.2) + ((Me.SpinButton9.Value / 100) *
0.09)), "##,##0.00%")


End Sub


Thanks for the assistance
Dave