MsgBox problem

[plockey]

I am trying to code this message box:
MsgBox "FullPieceQuantity:", FullPieceQuantity, " = STDPieceQty:", STDPieceQty
and get this run-time error.
�Invalid procedure call or argument�
Any ideas on as why?

Thanks
Paul

[theDude]

You are passing invalid data to the arguments of the MsgBox function. From VB help:

MsgBox Syntax

MsgBox(prompt[, buttons] [, title] [, helpfile, context])

The MsgBox function syntax has these named arguments:
prompt Required. String expression displayed as the message in the dialog box. The maximum length of prompt is approximately 1024 characters, depending on the width of the characters used. If prompt consists of more than one line, you can separate the lines using a carriage return character (Chr(13)), a linefeed character (Chr(10)), or carriage return – linefeed character combination (Chr(13) & Chr(10)) between each line.

buttons Optional. Numeric expression that is the sum of values specifying the number and type of buttons to display, the icon style to use, the identity of the default button, and the modality of the message box. If omitted, the default value for buttons is 0.

title Optional. String expression displayed in the title bar of the dialog box. If you omit title, the application name is placed in the title bar.

helpfile Optional. String expression that identifies the Help file to use to provide context-sensitive Help for the dialog box. If helpfile is provided, context must also be provided.

context Optional. Numeric expression that is the Help context number assigned to the appropriate Help topic by the Help author. If context is provided, helpfile must also be provided.

It appears that you only want to pass the prompt to the message box, but you separated text and variables with a comma, which is interpreted by Excel as a new argument. Use the ampersand '&' symbol instead of commas like this:

Please Login or Register  to view this content.

Hope this helps,
theDude