Set display-positiom of MsgBox() function

[ElBombay]

Hello Board,

Is there a way to set where the MsgBox() function displays on the screen? The Board has helped me previously with an elaborate use of Text boxes but I'm just looking to call MsgBox(), with its Yes/No/Cancel/etc. options and place that question-box in a corner that won't obscure the worksheet. I've tried a few searches but can't get the feedback I' looking for. Thanks.

 

[wideboydixon]

You can do it using a hook like this:

http://www.excely.com/excel-vba/define-a-position-of-messagebox.shtml

Alternatively, you could create your own message box UserForm which allows you to control the position.

WBD