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?

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?

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?

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?