Please Help

  • Thread starter Thread starter Greg B
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Code to format cells on several worksheets 2
ested IF wont work as I need 18 1
Creating A List of Items Between Two Numbers 2
change controlsource for textbox depending on combobox selection 2
Textbox values won't change untill clicked on!!!!!!!!!! 2
Duplicates in column 5

Back
Top