Thread: MsgBox Help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default MsgBox Help

On 14 Dec., 01:13, millwalll
wrote:
Hi all need some help I have got message box the code for the box is

MsgBox (Sheet2.Range("a2").Value & " has the most Expensive Phone to buy
Initially")

And I want to add a Vbokonly and vbinformation to it so it only display a ok
button and the information image.
(vbOKOnly + vbInformation)

The code I thought would be somthing like this.
MsgBox (Sheet2.Range("a2").Value & " has the most Expensive Phone to buy
Initially",vbOKOnly + vbInformation)

But this is not working so any help or advice thanks all :)


msg = MsgBox(Sheet2.Range("a2").Value & " has the most Expensive Phone
to buy Initially ", vbOKOnly + vbInformation)