Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|