Modeless MsgBox (Excel 2000)

Topic

New Reply

I want the user to have an option to change something on a spreadsheet in the middle of a macro.
I thought I’d simply display a modeless msgbox which the user could click on when ready, but I can’t figure out how to do this. Do I have to create my own form?

Reply | Quote

Replies

> Do I have to create my own form?

Yes, a MsgBox is always modal, and there is no way to change that. You can create a userform that looks like a message box, and open it with the Modal argument set to False:

UserForm1.Show False

or set the ShowModal property of the userform to False.

Reply | Quote

Thanks, Hans.
I’m always looking for the fastest way!

Reply | Quote