KlausW
Active Member
- Joined
- Sep 9, 2020
- Messages
- 385
- Office Version
- 2016
- Platform
- Windows
Hi, I found this VBA code here on MrExcel and it works really well. The only thing I could think of was that I should not enter any text in column D and press ENTER. If I stand in column D and do not type anything, the VBA code does not run. But if I write something in column D run the VBA code. Anyone who can help? Any help will be appreciated. Best Regards Klaus W
VBA Code:
Private Sub worksheet_change(ByVal target As Range)
If Not Intersect(target, Sheets("Prisliste").Range("d9:d4000")) Is Nothing Then
Call Prisliste_Overfør_Varer_Klik
End If
End Sub