View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default MsgBox - place and size?

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.

--
Regards,
Tom Ogilvy



"Einar" wrote in message
...
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("A17:D17").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 A17:D17

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

Einar