Can you not put the code in your spin up and spin down commands?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"transferxxx" wrote:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target = Cells(1, 1) Then Filternonblank
End Sub

The above macro does not work when changing cell A1 value with a spinner
button
Can anybody help pls