Hello.
At the moment I have InputBox, MsgBox and Application.InputBox(Type=1) functions, however when running through the macro the Application.InputBox pops up in a different part to its error window and also the other InputBox and MsgBox functions.
So how do I get them to all, say, pop up with their left hand corner at Cell H3.
Thank you.
Why does it matter? As long as it can be seen surely no-one will care?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Some quick googling gave me this: http://social.msdn.microsoft.com/For...e-and-position
Though it seems to be more trouble than it's worth, if you ask me :P
The 3 built in functions might be cosmetically unaesthetic, but it were important enough, you could see if using a User Form to combine the 3 functions would work. At least it would be in the same position each timeOriginally Posted by hugh1994
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
InputBox and Application.InputBox have Left and Top arguments that can be used to position them.
Reply With Quote
