ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,279
- Office Version
- 2007
- Platform
- Windows
I have a code which transfers values from the open workbook to another workbook & all works fine.
I now need to add an if statement Before the main code runs.
Customers name is always in column A
The value to check if present or not is always in column I
The value to check for is KDX 2
So it should work like this.
A customer is selected in column A
The code must look in column I on this customers row & if KDX 2 is present then allow the rest of the code which i have currently in use.
If there is any other value in column I then show MsgBox & stop the code from running.
I think i can do it it the customer was selected in the same cell in column A every time BUT unsure when it could be anywhere
I now need to add an if statement Before the main code runs.
Customers name is always in column A
The value to check if present or not is always in column I
The value to check for is KDX 2
So it should work like this.
A customer is selected in column A
The code must look in column I on this customers row & if KDX 2 is present then allow the rest of the code which i have currently in use.
If there is any other value in column I then show MsgBox & stop the code from running.
I think i can do it it the customer was selected in the same cell in column A every time BUT unsure when it could be anywhere