Thread: msgBox problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jeff Ciaccio Jeff Ciaccio is offline
external usenet poster
 
Posts: 17
Default msgBox problem

That did the trick, but how does the following work?? Notice the
parenthesis are included, and this compiles and runs fine. Wierd :)
msg = MsgBox(OutputString, Title:="Your prime numbers")


"Sandy Mann" wrote in message
...
Try removing the parenthesis:

MsgBox "Time period 1: " & vbLf & "The ending velocity was " & vel & _
" m/s, and the starting velocity was " & vInit1 & ", so the Delta v was "
_
& (vel - vInit1) & " m/s", Title:="End of first period"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jeff Ciaccio" wrote in message
...
I would like to used named parameters in a msgBox, but this does not seem
to work.
MsgBox ("Time period 1: " & vbLf & "The ending velocity was " & vel & "
m/s, and the starting velocity was " & vInit1 & ", so the Delta v was " &
(vel - vInit1) & " m/s", Title:="End of first period")

When I leave off the named paramter, it works just fine (without a
title).
MsgBox ("Time period 1: " & vbLf & "The ending velocity was " & vel & "
m/s, and the starting velocity was " & vInit1 & ", so the Delta v was " &
(vel - vInit1) & " m/s")

Am I doing something wrong with the named parameter?

Thanks

--
Jeff Ciaccio
Physics and AP Physics Teacher
Sprayberry High School; Marietta, GA
Blog:
http://sprayberry.typepad.com/ciaccio