I am needing the code below to be changed so it also shows cell c1 aswell in
the same textbox.

TextBox1.Text = Worksheets("TEAM1").Range("B1").Value

Thanks in advance

Greg

I need to have a gap between the values. How do I do this I have got this
code so far?
TextBox1.Text = Worksheets("TEAM1").Range("B1").Value &
Worksheets("TEAM1").Range("C1").Value

Thanks again

"Greg B" wrote in message
...
I am needing the code below to be changed so it also shows cell c1 aswell
in
the same textbox.

TextBox1.Text = Worksheets("TEAM1").Range("B1").Value

Thanks in advance

Greg

Just add
" " &
after your &

It could just as easily be a prefix or suffix, too e.g.
Range("A1").value= Range ("A2").formula & "This is some text" &
range("A3").formula

Cheers

Pete



"Greg B" wrote:

I need to have a gap between the values. How do I do this I have got this
code so far?
TextBox1.Text = Worksheets("TEAM1").Range("B1").Value &
Worksheets("TEAM1").Range("C1").Value

Thanks again

"Greg B" wrote in message
...
I am needing the code below to be changed so it also shows cell c1 aswell
in
the same textbox.

TextBox1.Text = Worksheets("TEAM1").Range("B1").Value

Thanks in advance

Greg