|
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? |
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? |
| All times are GMT +1. The time now is 07:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com