sandesh_dz
New Member
- Joined
- Oct 22, 2015
- Messages
- 3
In column B. I need to check cells in random order. If there is value then display msg box.
For eg
If cell B3 value = ABS then msg box "Please use ABS view"
if cell b5 calue = 50% then msg box"value should be greater than 90%"
The problem I am facing is the macro keeps on displaying msg box for B3 and not going ahead. If b5 has value below 90% it still shows msg box for B3. There are more values i need to check one by one it should show msg box and then go ahead for next check
For eg
If cell B3 value = ABS then msg box "Please use ABS view"
if cell b5 calue = 50% then msg box"value should be greater than 90%"
The problem I am facing is the macro keeps on displaying msg box for B3 and not going ahead. If b5 has value below 90% it still shows msg box for B3. There are more values i need to check one by one it should show msg box and then go ahead for next check