| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| Spinner Button - Incremental Change | Excel Discussion (Misc queries) | |||
| Spinner Button Reset | Excel Discussion (Misc queries) | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Linear Mode
