Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: MessageBox - simple problem

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a messageBox popup that works fine when the focus ( my cursor) is on Excel .. however .. if I am using another windows programme .. and the excel condition is met whereby the MessageBox should popup .. ie an alert .. then it doesnt .. instead the Excel icon just flashes at the bottom of the screen. When I click on Excel .. the messagebox appears.

    Is there any way of making the messagebox popup on the excel worksheet even when I am in another application .. as users are missing this message .. which is understandable cos its not that apparent if they are busy.

    Thanks
    Bill

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Bit of a shot in the dark here, but see what happens if you put
    Application.visible = False
    to hide Excel before the msgbox code and then
    Application.visible = True
    afterwards to bring it back.

    I'm guessing (wildly) that the msgbox will still have to appear somewhere even if the Excel application is not visible, and will therefore head for the very front of the screen.

    Rgds
    AJ


  3. #3
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't know if this will work because I don't have a quick way to send data to excel externally.

    Anyway, I would try putting a line like this before your msgbox:


    Windows("Book1.xls").Activate


    HTH

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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