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

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

Thanks Julie,

Yeah I should go to bed but I am writing this program for my sister to use

Thanks for the help

Greg

where in Oz?

"Greg" wrote in message
...
Thanks Julie,

Yeah I should go to bed but I am writing this program for my sister to use

Thanks for the help

Greg

Adelaide.

perth ... and it's 2am here !!!!

"Greg" wrote in message
...
Adelaide.