| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need 2 create userform that uses data from rows...HELP.
I have this worksheet that will consist of a variable amount of rows. I need
the user to be able to select a cell (thus it would consitute it as if they were selecting the entire row) and that data to show up on a userform. I have tried to use: iRow = ActiveCell.Row frmUserform.Caption = Caption & " " & Worksheet("Project").Cells(iRow,1) However I have to click the command button to open the form. Then close the form, and open it again via the command button; then it will show the correct data. The reason I am doing it this way is because I have 256 cells per a row and wish to create an easy interface to edit the cells. Does anyone have ideas of what I am doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create additional rows containing data from one original row | Excel Discussion (Misc queries) | |||
| Link data in rows to columns to create table | Excel Discussion (Misc queries) | |||
| Create charts that update automatically from data in rows | Charts and Charting in Excel | |||
| how to create ado recordsets from rows of data? | Excel Programming | |||
| Adding rows to create list from DDE data | Excel Programming | |||
Threaded Mode
