msgBox problem

  • Thread starter Thread starter Jeff Ciaccio
  • Start date Start date
J

Jeff Ciaccio

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
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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")
 
Because the response from the Mesaage Box, (ie the button pressed), is being
assigned to the variable msg. The Parenthsis in you original code was
making XL think that you want to assign a variable and so it said that it
expected a "=". With no parenthsis is just give a message so no assignment
is necessary.

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top