View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Einar Einar is offline
external usenet poster
 
Posts: 12
Default MsgBox - place and size?

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