Please Help

[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

[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

"Greg B" <laptopgb@ihug.com.au> wrote in message
news:d5c6pr$kqt$1@lust.ihug.co.nz...
> 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
>
>

[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



"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" <laptopgb@ihug.com.au> wrote in message
> news:d5c6pr$kqt$1@lust.ihug.co.nz...
> > 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
> >
> >
>
>
>