View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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