Hi flahsdisk,

I have a golf spreadsheet where I enter hole strokes into a userform. Here is the code that uses an INDEX number of the controls on the userform to add up the first 9 holes scores.

'Total strokes when 9th hole is input
Private Sub H9_Change()
Dim Index As Integer

Me.F9G.Value = 0
For Index = 1 To 9
    Me.F9G.Value = Me.F9G.Value + CInt(Me(Index))
Next Index

'    Me.F9G.Value = CInt(H1) + CInt(H2) + CInt(H3) + CInt(H4) + CInt(H5) + CInt(H6) + CInt(H7) + CInt(H8) + CInt(H9)
End Sub
The idea is that each control on a userform has an index number. So you do a loop through the index numbers to add stuff up. Hope this example helps.