Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 379
- Office Version
- 365
- Platform
- Windows
Good afternoom,
I got the following VBA code.
I got a a table with the columns H, I and J. The value of column H (Magazijn) has be 1, column I (Locatie) has to be "AAP" and column J (Voorraad) has to be <>0. When all those values match then the line has to be counted
Can this be done?
Thank you for your time and have a great day.
I got the following VBA code.
VBA Code:
Mag1LocAAP.Caption = "AAP" & Chr(10) & Application.CountIf(Range("Locatie[Locatie]"), "=AAP")
I got a a table with the columns H, I and J. The value of column H (Magazijn) has be 1, column I (Locatie) has to be "AAP" and column J (Voorraad) has to be <>0. When all those values match then the line has to be counted
Can this be done?
Thank you for your time and have a great day.