| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
listbox
I have a listbox on a userform to select a item in a column, that works
fine! Upon selection i want to pick up values from other cells in the row of my selection for editting in textboxes on another userform. Can anyone point me in the right direction on how i can achieve this? |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
|
listbox
Oggy
If you have the selection set up then depending on how you have this use the offset property to get data from other cells in the row or other columns, like so Range("A1").Offset(0,1).Value will get the value in B1 You can use negatives to refer to cells left or up. The selection using this property is NOT changed -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Oggy" wrote in message ups.com... I have a listbox on a userform to select a item in a column, that works fine! Upon selection i want to pick up values from other cells in the row of my selection for editting in textboxes on another userform. Can anyone point me in the right direction on how i can achieve this? |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
|
listbox
Thanks Nick,
how do i make the cell i selected in the list the active cell to work from so the i can make my code as follows Range(selection).Offset(0,1).Value Thanks very much for your advise, much appriecated regards Oggy Nick Hodge wrote: Oggy If you have the selection set up then depending on how you have this use the offset property to get data from other cells in the row or other columns, like so Range("A1").Offset(0,1).Value will get the value in B1 You can use negatives to refer to cells left or up. The selection using this property is NOT changed -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Oggy" wrote in message ups.com... I have a listbox on a userform to select a item in a column, that works fine! Upon selection i want to pick up values from other cells in the row of my selection for editting in textboxes on another userform. Can anyone point me in the right direction on how i can achieve this? |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
|
listbox
Oggy
If the cell is a single cell then Selection.Offset(0,1).Value If it is likely to be more than 1 then (or anyhow) ActiveCell.Offset(0,1).Value As you can only have 1 active cell -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Oggy" wrote in message ps.com... Thanks Nick, how do i make the cell i selected in the list the active cell to work from so the i can make my code as follows Range(selection).Offset(0,1).Value Thanks very much for your advise, much appriecated regards Oggy Nick Hodge wrote: Oggy If you have the selection set up then depending on how you have this use the offset property to get data from other cells in the row or other columns, like so Range("A1").Offset(0,1).Value will get the value in B1 You can use negatives to refer to cells left or up. The selection using this property is NOT changed -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Oggy" wrote in message ups.com... I have a listbox on a userform to select a item in a column, that works fine! Upon selection i want to pick up values from other cells in the row of my selection for editting in textboxes on another userform. Can anyone point me in the right direction on how i can achieve this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
| avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
| VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
