Kiran2229Kiran
New Member
- Joined
- Jul 15, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hello,
I am new to VBA. I have gone through many other blogs but, found this channel very helpful and active. I need to fulfill this requirements. Please help Me in the below requirements?
Thanks in advance.
***We need to restrict user for save and close to ensure the below requirements and need to handle all the rows in the respective columns***
1a. Columns ‘A’, ‘B’, ‘C’, ‘D’, ‘E’, ‘F’, ‘G’ and ‘I’ are mandatory. User needs to provide data in these columns else we need to restrict user from closing and saving excel.
1b. Need to handle all the cells and need to ask user to Provide missing value in corresponding cell of a column let us say ‘CELLxyz’ of column ‘COLUMNabc’ respectively.
2a. 'Column A’ should have unique values (we need to generate or propose unique values) else it should throw an error for the corresponding cell with duplicate values.
Let us say ‘CELLxyz’ in ‘COLUMN A’ have duplicate values.
2b. Requirement is to automatically generate the below sequence in 'Column A' from ‘A1’ to ‘An’.
Example:
XYZ1000
XYZ1001
XYZ1002
The sequence for ‘Column A’ should begin with XYZ1000.
2c. If user tries to enter data excluding the above sequence, then we need to restrict.
2d. When user tries to create or insert a new record the next number should be populated in 'Column A’ automatically i.e. XYZ1003.
Regards,
Kiran
I am new to VBA. I have gone through many other blogs but, found this channel very helpful and active. I need to fulfill this requirements. Please help Me in the below requirements?
Thanks in advance.
***We need to restrict user for save and close to ensure the below requirements and need to handle all the rows in the respective columns***
1a. Columns ‘A’, ‘B’, ‘C’, ‘D’, ‘E’, ‘F’, ‘G’ and ‘I’ are mandatory. User needs to provide data in these columns else we need to restrict user from closing and saving excel.
1b. Need to handle all the cells and need to ask user to Provide missing value in corresponding cell of a column let us say ‘CELLxyz’ of column ‘COLUMNabc’ respectively.
2a. 'Column A’ should have unique values (we need to generate or propose unique values) else it should throw an error for the corresponding cell with duplicate values.
Let us say ‘CELLxyz’ in ‘COLUMN A’ have duplicate values.
2b. Requirement is to automatically generate the below sequence in 'Column A' from ‘A1’ to ‘An’.
Example:
XYZ1000
XYZ1001
XYZ1002
The sequence for ‘Column A’ should begin with XYZ1000.
2c. If user tries to enter data excluding the above sequence, then we need to restrict.
2d. When user tries to create or insert a new record the next number should be populated in 'Column A’ automatically i.e. XYZ1003.
Regards,
Kiran