Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    MsgBox Position (VBA/Ecxel/2000)

    Hello again
    I am a little surprised that there doesn't seem to be any facility to position a message box on the screen, as there is with an Input box. Can anyone offer insight or a work-around?
    Regards
    Don

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MsgBox Position (VBA/Ecxel/2000)

    You'd need advanced use of Windows API functions to position a message box - see How To Position a MsgBox Using a Windows Hook Procedure and the thread starting at <post#=345458>post 345458</post#>, in particular the replies by <!profile=MarkD>MarkD<!/profile>.

    It would probably be simpler to create a userform that looks like a message box.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MsgBox Position (VBA/Ecxel/2000)

    Thank you Hans
    You've confirmed my fears; but it looks like a good learning experience.
    Regards
    Don

Posting Permissions

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