Positon of Message Box

[cmonthetic]

Hi,

Using Excel 97.

Simple question I think :|, is it possible to set the position of a message box.

I am trying to get the message box to display on screen so that it does not cover over the user input form that is displayed in the centre of the screen.

TIA

 

[PHV]

The Application.InputBox method admits coordinates.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[xlbo]

could probably use an API call but you may be better off faking it with a userform which you can set the startup position of easily in the form properties

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[Horowitz]

hi cmonthetic,

I think the best you can do is to add a windows form in your project with a label on it. Set the form to appear for example at down-right of your screen. If something would trigger a messagebox to appear... call the form (form.show()) and then label1.text= "your message". Then add a timer and when 10 seconds pass; hide the form, or better "play with the opacity" method so as the form slowly hides

Respond to me, (hope u understand my poor english)

 

[cmonthetic]

Thanks for the reply's.

Didn't need to re-position the message box after all as the end user wanted the message box to appear over the input form so the user had to confirm or reject if they had reviewed the input in the form.

In both instances either Yes or No the message box is terminated so it dosen't cause an issue any more.

Once again, thanks for the response's