Hi

[Arif_Tamboli]

Column A range 1 to 10 date should appear in range n1 cell on every click (up and down ) spin button

 

[MickG]

Try this:-

Private Sub SpinButton1_Change()
Dim Rng As Range
Set Rng = Range("A1", Range("A" & Rows.Count).End(xlUp))
    SpinButton1.Min = 1
    SpinButton1.Max = Rng.Count
    Range("N1").Value = Format(Rng(SpinButton1), "dd/mm/yyyy")
End Sub