Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Positon of Message Box

Status
Not open for further replies.

cmonthetic

IS-IT--Management
Oct 18, 2004
27
GB
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
 
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
 
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
 
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)
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top