Try something like

Me.TextBox1.Text = "Cell B1 is " & Format(Range("B1").Value,"#,##0")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 3 Oct 2009 16:04:01 -0700, JMay
wrote:

How do I do this?

My Cell B1 contains the number 55.

I want my textbox to read

"Cell B1 is 55",

But HOW???????????