Hi,

I am trying to put a concatenate function in a text box. The error
message is as follows:

The text you have entered is not a valid reference or defined name.

I want to concatenate some text with a number from the cell, A2.

Any ideas would greatly appreciated.

Regards

Tubbsy


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

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