Consulting

Results 1 to 4 of 4

Thread: Solved: Display userform pause code

  1. #1

    Solved: Display userform pause code

    Hi--- This problem seems pretty basic, but for some reason I can't find the appropriate means of resolving it.
    Here is the deal. At some point in my macro, I want to display a message box, and pause the code until the user presses ok. The catch is that I want the user to be able to browse through the workbook (look at other worksheets, scroll through the sheets, possibly even edit the data), while the msgbox is up. Modeless forms don't work, because the code keeps running.

    The solutions that I managed to find so far, all try to somehow work around the problem. Is there a direct way to do this?

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try

    [vba]

    ans = Application.InputBox("You can browse the workbook, press oK to quit",Type:=8)
    [/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Wow!... that was easy. Thank you very much!

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    It's not idea, but it works.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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