Hi Greg

do you want to add (+) the value in A1 with the value in B1 or concatenate
it?

to add use
TextBox1.Text = Worksheets("R2").Range("A1").Value +
Worksheets("R2").Range("B1").Value

to concatenate use
TextBox1.Text = Worksheets("R2").Range("A1").Value &
Worksheets("R2").Range("B1").Value

Cheers
JulieD
(you're working late)

"Greg" wrote in message
...
TextBox1.Text = Worksheets("R2").Range("A1").Value

I am using the code above to get text on to a userform how can i change
this
to get the information from cell "b1" as well in this same textbox?

Thanks

Greg