Worksheet change event - Spinner button
 

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

Worksheet change event - Spinner button
 

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

Worksheet change event - Spinner button
 

Why not just use code associated with the spinner?

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

--

Dave Peterson

Worksheet change event - Spinner button
 

how can this be done pls

"Dave Peterson" wrote:

Why not just use code associated with the spinner?

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

--

Dave Peterson

Worksheet change event - Spinner button
 

Pls show me how as i'm using a standard spinning button


"John Bundy" wrote:

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

Worksheet change event - Spinner button
 

Did you use the spinner from the control toolbox toolbar or the spinner from the
Forms toolbar?

The code is different.



transferxxx wrote:

how can this be done pls

"Dave Peterson" wrote:

Why not just use code associated with the spinner?

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

--

Dave Peterson


--

Dave Peterson