work behind msgbox

[Nazrul]

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

[Norman Jones]

Hi Nazrul,

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

---
Regards,
Norman



"Nazrul" <[email protected]> wrote in message
news:[email protected]...
> 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