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. |
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 |