VBA update and clear the value without delay

[elsuji]

Hi Sam,

Thanks for your help. Now the code is working as per my requirement.