Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VB - show userform1 (at same time) minimized application win Dr.CIMS Excel Discussion (Misc queries) 1 September 13th 07 02:14 AM
UserForm1.show fails if another workbook is open gary Excel Programming 3 June 25th 06 04:21 PM
What's the difference between 'Set UserForm1=Nothing' and 'Unload UserForm1' ? Zoo Excel Programming 1 May 11th 06 04:18 PM
VBmodeless jeffP Excel Programming 0 June 25th 04 05:12 AM
SetFocus to first textbox on userform upon Userform1.Show Paul Simon[_3_] Excel Programming 6 February 11th 04 04:31 PM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"