how do i use UserForm1.Show vbModeless command?
 

If you are talking about a msgbox generated with
MsgBox "Some Message"
then it will always be modal.

However, if you make your own msgbox (as your subject suggests) then it is
not modal.

NickHK

"trapper" wrote in message
...
i want msgbox to stay in view while working on the cells in the spread
sheet.
default stops all work till make msgbox go away by clicking ok

how do i use UserForm1.Show vbModeless command?
 

thanks. will generate own

"NickHK" wrote:

If you are talking about a msgbox generated with
MsgBox "Some Message"
then it will always be modal.

However, if you make your own msgbox (as your subject suggests) then it is
not modal.

NickHK

"trapper" wrote in message
...
i want msgbox to stay in view while working on the cells in the spread
sheet.
default stops all work till make msgbox go away by clicking ok