Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells to a txtbox
I am creating a user form to display data that is hard to read in a
spreadsheet. The sheet will have about 20 cells of data in each row, so this may be very simple but what process can I use to grab the current row, or even start at row 2 and paste cells into text boxes. Then the next problem I will put a NEXT button on the form to move one row down and then grab the data in those 20 cells There must be a better way than the following: txtOrginazation.Value = Worksheets("Open projects").Range("A2").Value txtDate.Value = Worksheets("Open projects").Range("B2").Value txtET.Value = Worksheets("Open projects").Range("C2").Value Thanks for any input. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells to a txtbox
Hi, I'm putting data from cells into textbox this way:
x=range("A2").text Textbox1.text=x If you wann to put datas from more the one cell into same textbox then use for next cell: Textbox1.text=Textbox1.text & x 'where x is the text from another cell for example A3 Henrich €žSMERTZ" napÃ*sal (napÃ*sala): I am creating a user form to display data that is hard to read in a spreadsheet. The sheet will have about 20 cells of data in each row, so this may be very simple but what process can I use to grab the current row, or even start at row 2 and paste cells into text boxes. Then the next problem I will put a NEXT button on the form to move one row down and then grab the data in those 20 cells There must be a better way than the following: txtOrginazation.Value = Worksheets("Open projects").Range("A2").Value txtDate.Value = Worksheets("Open projects").Range("B2").Value txtET.Value = Worksheets("Open projects").Range("C2").Value Thanks for any input. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
txtbox no right click copy menu available? | Excel Programming | |||
txtbox problem | Excel Programming | |||
To put value from txtbox to cell? | Excel Programming | |||
Validateing a txtbox from form | Excel Programming | |||
txtbox code | Excel Programming |