VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,232
Hi All,
above is my current scenario. On cell move event, i need vba code.
If values gets enter in either a or b column cell then c and d both should get disable.
If values gets enter in either c or d column cell then a and b both should get disable.
Can anyone help with code pls..
column A - and below is the a7 | Col B | Col C | Col D - contain list - data validation |
---|---|---|---|
blank | 100 | disable | disable |
50 | 100 | disable | disable |
disable | disable | 100 | USD |
disable | disable | 50 | INR |
above is my current scenario. On cell move event, i need vba code.
If values gets enter in either a or b column cell then c and d both should get disable.
If values gets enter in either c or d column cell then a and b both should get disable.
Can anyone help with code pls..