MsgBox - place and size?

[Guest]

Hi everybody.
How do I Place a msgbox or textbox right over a spesific cell?

My makro looks like:

Sub MyMacro()
Sheets("One").Activate
Range("A1717").Select
MsgBox "Text" & Chr(13) & Chr(13), vbInformation + vbOKOnly, "Title"
End Sub

I have tryed, top:=100, left:=100, but it wont work.
I want to place the MsgBox rigth over A1717

Is there enyone who know how to set the size of the MsgBox too?

Einar

 

[Tom Ogilvy]

If you want that type of control, the easiest thing to do is use a userform.
Otherwise, you will have to utilize the windows API to handle the message
box as a window.

In any event, the msgbox sizes dynamically according to the Message in the
box. It doesn't accept any arguments for size or position.