+ Reply to Thread
Results 1 to 3 of 3

Modeless Form from Modal Form

  1. #1
    Forum Contributor
    Join Date
    07-23-2016
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    273

    Modeless Form from Modal Form

    Is there any way I can show a form Modelss (VbModeless) from a modal form? I get an error when I try

    Userform1. Show vbModal

    then when a command button is clicked on the Userform1, I want to start a "progress" type userform that is updated as the data is processed in the command button routine, i.e., UserProgressForm.Show vbModeless then update the UserProgressForm to show the progress by altering a label.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Modeless Form from Modal Form

    Try adding DoEvents after your vbModal line.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Modeless Form from Modal Form

    You cannot show a modeless userform from a modal userform, unfortunately.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Changing the focus to worksheet while a modal/modeless form has stopped the code
    By CyrusMMX in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2016, 10:34 AM
  2. Non modal form closes with modal form when it is closed
    By ryan.wherry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2015, 12:45 PM
  3. Showing a modeless form on top of a modal form
    By foxguy in forum Excel General
    Replies: 15
    Last Post: 09-06-2010, 03:23 PM
  4. Modeless form blanks out
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2010, 09:19 PM
  5. Modeless form blanks out
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2010, 09:04 PM
  6. When was Modal/Modeless Form option born
    By Ken Soenen in forum Excel General
    Replies: 2
    Last Post: 11-04-2005, 06:25 PM
  7. Non -Modal form disappears
    By Chris W in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1