View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default new line in msgbox text

Hi Patrick,

Try:

MsgBox "This is on one line " & vbNewLine & "This is on the next"

---
Regards,
Norman



"Patrick" wrote in message
...
what character(s) do you use to put a new line in msgbox text

msgbox "This is on one line ??? This is on the next"

I expect its easy but have tried lots of things!

Thanks
--
Patrick