Pop Up Box

[DDREW]

I have written a code to which loops through a range to return a string message into a Msg Box. My questions: Is there a way to display Msg box or use another pop up or object box that would allow the user to continue working in excel while message is displayed? I am bascially looking for a pop up window the suer can read while they continue working. Thank you for any input...

 

[Deepak]

Hi,

You can use a userform with modeless property for the same.

UserForm1.Show False
AppActivate Application.Caption

Check below link for ref on the same.

http://chandoo.org/forum/threads/re-activate-active-cell-when-userform-is-shown.17601/#post-106631

 

[DDREW]

Deepak, As always thank you! It work great!

 

[Deepak]

Welcome!!!