Hi,
I've a file that uses user respone to navigate through a number of charts like a slide show (not my work - downloaded from PHD I think).
To move from one 'slide' to the next users are required to select "Ok" on a OK/Cancel Msgbox.
By default the MsgBox pops up in the middle of the screen.
I'd like to control the position of the MsgBox programmatically.
Is this possible?
Hello Jbentley,
That depends on the message box. If these are MsgBox dialogs then the answer is yes you can control their position, but it requires API programming. If these are VBA UserForms, the answer again is yes and are far easier to position.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Messagebox...no. No controls exist for that. But you can use an INPUTBOX instead which does let you.
For instance:
(Source)
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Leigh / JB: Thanks for the replies.
Leigh: Apologies for the duplicate post - I futzd the first post and wasn't sure if it's had submitted correctly .
JwB
Last edited by Jbentley; 09-17-2009 at 01:07 AM. Reason: spelling
A UserForm is probably more adaptable and can be positioned using Chip Pearson's Form Positioner
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks