move message box display from center of screen to one side

[trium123]

Hi All
I have a confirmation window which appears when i click a button. The message asks the user to confirm that the selection is correct, however the message appears in the center of the screen, i would like it to appear to the middle left of the screen.
Can this be done in code and if so does anyone know the syntax?
Thanks for your guidance.

 

[PHV]

I have a confirmation window which appears when i click a button
How do you do that ?
Take a look at the InputBox VBA function, the Xpos and YPos (4th and 5th) arguments.

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