Good evening oberon.black

This line should do the trick.

TextBox2.Value = Range("A12") & "," & Range("E12")

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=46838