Dictating MsgBox Location

[f64]

Is it possible to control the location where a MsgBox appears on a UserForm? I am testing data entered into a textbox, and if the test fails a MsgBox appears onscreen. Unfortunately, it covers up the textbox being tested. If possible, I would like the textbox to be visible after the MsgBox appears. Is it possible to dictate the location onscreen where the MsgBox will appear?

 

[CajunCenturion]

In answer to your question, not very easily, and even then requires the use of a number of API's. You'd be better off writing your own form to function as a messsagebox.

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[PHV]

You may consider the InputBox function.

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