DavyJones90
Board Regular
- Joined
- Feb 23, 2022
- Messages
- 62
- Office Version
- 365
- Platform
- Windows
I have a problem with Private Sub Worksheet_Change(ByVal Target As Range), as I have a lot of code in my workbook, I had to split it into several parts an Target them
So every time there is a change in the workbook it runs through 14 different subs
EURUSDTarget Target
AUDUSDTarget Target
GBPUSDTarget Target
EURGBPTarget Target
USDCHFTarget Target
EURCHFTarget Target
USDJPYTarget Target
AUDJPYTarget Target
EURJPYTarget Target
GBPJPYTarget Target
DXYTarget Target
XAUTarget Target
LCOC1Target Target
ZARTarget Target
Is there a way how it will stop targetting the next sub if one of them executed, till the next time a cell value changes?
So every time there is a change in the workbook it runs through 14 different subs
EURUSDTarget Target
AUDUSDTarget Target
GBPUSDTarget Target
EURGBPTarget Target
USDCHFTarget Target
EURCHFTarget Target
USDJPYTarget Target
AUDJPYTarget Target
EURJPYTarget Target
GBPJPYTarget Target
DXYTarget Target
XAUTarget Target
LCOC1Target Target
ZARTarget Target
Is there a way how it will stop targetting the next sub if one of them executed, till the next time a cell value changes?