Please Help

G

Greg B

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
 
G

Greg B

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
 
P

Peter Rooney

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
 
Top