| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation List
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("H1").Value < "" Then Sheet3.Range("H1").Value = Sheet2.Range("H1").Value Sheet4.Range("H1").Value = Sheet2.Range("H1").Value Sheet5.Range("H1").Value = Sheet2.Range("H1").Value Sheet6.Range("H1").Value = Sheet2.Range("H1").Value End If End Sub -trying to auto change selected list item for each worksheet list -code above for sheet2, works fine -add and make the changes to sheet 3, works fine -do the same for sheet 4, 5, or 6, and it gets hung up ?when the list is updates on the other worksheets, does that trigger Worksheet_Change on all subsequent worksheets? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation List
Your code works fine (on my end).
"mike" wrote: Private Sub Worksheet_Change(ByVal Target As Range) If Range("H1").Value < "" Then Sheet3.Range("H1").Value = Sheet2.Range("H1").Value Sheet4.Range("H1").Value = Sheet2.Range("H1").Value Sheet5.Range("H1").Value = Sheet2.Range("H1").Value Sheet6.Range("H1").Value = Sheet2.Range("H1").Value End If End Sub -trying to auto change selected list item for each worksheet list -code above for sheet2, works fine -add and make the changes to sheet 3, works fine -do the same for sheet 4, 5, or 6, and it gets hung up ?when the list is updates on the other worksheets, does that trigger Worksheet_Change on all subsequent worksheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use VBA to reset data validation (=list) value to first value in that list (list is a named range) | Excel Programming | |||
| data validation invalid in dynamic validation list | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Linear Mode
