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?