Rearrange msgbox text order

[ipbr21054]

Hi,

Below is the current code in use.

MsgBox .Text & Chr(10) & "This Invoice Number Exists", vbCritical, "Duplicate Invoice Number"

This returns the message,
44
This Invoice Number Exists.

I am trying to get the output message to be like,

Invoice Number 44 Exists

I think ive had many combinations apart from the one i require.

Thanks

 

[Scott Huish]

MsgBox "Invoice Number " & .Text & " Exists", vbCritical, "Duplicate Invoice Number"

 

[ipbr21054]

Thank You