Can I create message box or user form that doesn't freeze the screen?

[tonywatsonhelp]

Hi everyone,

Ok so I have this macro that runs a warning message box when someone is about to send in there report saying this is the report you are about to send in are you happy?
it all works great except freezes the screen until they click yes or no.

I'd like them to be able to look at the sheet scroll up and down and view it before click yes or no.

is there a way to do this?

the macro I'm currently using is:

Sub WeeklyReportCheck1()

    Sheets("Weekly Report").Select
If MsgBox("This is the report you are submiting to Head Office? Do you wish to proceed?", vbYesNo, "Warning!") = vbNo Then Exit Sub
Call Weekly1

End Sub

 

[dmt32]

have a look here:http://www.mrexcel.com/forum/excel-...sibility-making-standard-msgbox-modeless.html

and see if any help

Dave

 

[tonywatsonhelp]

Wow,
Thanks dmt32,
indirectly it helped,
one of the comments was that they would just use shapes and as I think about it this makes perfect sense, rather than a message box I can just have yes no shape with macros attached surrounded buy another shape that holds the message and make the shapes visible

so i'll play about with this all day and see how it goes
thanks
tony