Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 379
- Office Version
- 365
- Platform
- Windows
Good afternoon,
I got this code and it works great, but can I let it look into another sheet. So this line works in my sheet called "Orders" with the table name "Orderregels", but what I now need to have it from a sheet called "Data" and table called "Datatable". The command button is on the sheet "Orders" and I need to get the information from sheet "Data" with table name "Datatable".
Can this be done?
Thank you for your time.
I got this code and it works great, but can I let it look into another sheet. So this line works in my sheet called "Orders" with the table name "Orderregels", but what I now need to have it from a sheet called "Data" and table called "Datatable". The command button is on the sheet "Orders" and I need to get the information from sheet "Data" with table name "Datatable".
Can this be done?
Thank you for your time.
VBA Code:
Fiatteren.Caption = "geen fiat" & Chr(10) & Application.CountIf(Range("Datasheet[Fiat]"), "=N")