ExcelBanter - work behind msgbox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - work behind msgbox (https://www.excelbanter.com/excel-programming/333892-work-behind-msgbox.html)

Nazrul[_3_]

work behind msgbox

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

work behind msgbox

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

All times are GMT +1. The time now is 12:07 PM.