Hi Nazrul,

To obtain this functionality, replace the MsgBox with a modeless userform.

---
Regards,
Norman



"Nazrul" wrote in message
...
Hi,

I want to change cell values while a messgebox is open. Basically, excel
does not allow me to change anything while macro is running. Is there
anyway
I can have modeless msgbox so that I can change cells values (or any
calcualtion) behind msgbox?

Thanks,
Nazrul