I was wondering if anybody knows how to concatenate the output from two textboxes for use in a message box?


Below is the code i have and i want to display

Lookup for (Value of Textbox 1 and Value of Textbox 2) not found.

I thought and ampersand would do the trick but it comes up with an error

MsgBox "Lookup for " & TextBox1.Text Textbox2.Text " not found"

Any suggestions appreciated

Regards

Colin