Its not a perfect solution but you could perform the concatenate
function in another cell, maybe hidden on another sheet, and then
reference that cell in the text box.

GW


--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=388332