Hello, I would like to ask if any vba function is available to perform the captioned function.
To illustrate what is to be achieved, below is the sample data:
Cell A1: 43
Cell A2: 31
When the above is input by the user, the below events are required:
1. Notification message pop-up and advise the user that the value of cell A2 should always larger or equal to A1, and;
2. Automatically swap the value of cell A1 and A2
The above should not be performed when only one of the cell (either A1 or A2) has value input (as this should be the case that the user is still on the way to fill in both values), or if value in cell A2 is already higher than A1 right after user input.
Many thanks for any help on the above. Cheers~!
To illustrate what is to be achieved, below is the sample data:
Cell A1: 43
Cell A2: 31
When the above is input by the user, the below events are required:
1. Notification message pop-up and advise the user that the value of cell A2 should always larger or equal to A1, and;
2. Automatically swap the value of cell A1 and A2
The above should not be performed when only one of the cell (either A1 or A2) has value input (as this should be the case that the user is still on the way to fill in both values), or if value in cell A2 is already higher than A1 right after user input.
Many thanks for any help on the above. Cheers~!