September 23, 202200:09:57

Lesson 53 Excel Vba Spin Button Use Data Invoice

Private Sub SpinButton1_Change()
SpinButton1.Min = 2

SpinButton1.Max = Sheet1.Range("A10000").End(xlUp).Row
Dim i As Long
i = SpinButton1.Value
TextBox1.Text = Sheet1.Cells(i, 1)

TextBox2.Text = Sheet1.Cells(i, 2)
Label3.Caption = i
End Sub