so are
ws.rng
and
rng.parent
the same?

--


Gary


"Tom Ogilvy" wrote in message
...
it is a reference to the worksheet that contains the range

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
tom:

i've seen rng.parent a couple of times today. can you explain what it's used
for?

--


Gary


"Tom Ogilvy" wrote in message
...
dim rng as Range, idex as Long, rw as Long
With Combobox1
set rng = Range(.RowSource).Columns(1).Cells
End with
idex = .ListIndex + 1
End with
rw = rng(idex).row
Textbox1.Value = rng.parent.Cells(rw,6).Text
Textbox2.Value = rng.parent.Cells(rw,7).Text

--
Regards,
Tom Ogilvy

"Corey" wrote in message
...
When i select value from a list in a Combobox, how do i fill some textboxes
with other values
from the same row as the selected Combobox value.
EG.
If A10 was the selected value for the Combobox
How do i do this :
IE.
Textbox1.value = Combobox1.Offset(0,5).Value ? ' (A15)??

Corey....