Hi Clare

No need to do that. Change your third line thus:

Label1.Caption = "P0" & a + 1

or

TextBox1.Value = "P0" & a + 1

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=384541