I've posted an example file to the files page on the Group home page
which shows how to do this. I've shown how to write the value both to a
text box and to a label.

I've tried your example file to another project. But
i'm still confused, why when i write rowsource at
properties windows still error.And why my procedure
about vlookup  still false.

A few days, u bring to this group file example about
vlookup vba. And i try to another project refer to
vlookup vba  to. But in this case, i still trouble,
when i write range tabel at properties windows in VBA.
And my procedure vlookup  still error to.
Can u help me about this problem. Now, my attach file
(s1 Dist NTG.XLS) again.

OK. I've now replied to your earlier post about your VBA vlookup  use not
working, so hopefully you've now got that fixed.

I think what you're saying is that you are trying to type in the name of
a range as the row source property for a control and it's not working,
although you don't say what's happening - are you getting an error
message, do you just get a blank list, or what? If there is a problem
with using the range name, check you have actually defined the name on
the worksheet and that you're spelling it correctly in the properties
table - and that there are no spaces or other punctuation in either
occurance of the name.

Error after i type in the name of a range in the
Property is " Could Not Set The RowSource Property.
Invalid Property value ".
Acctually defined the name on the worksheet and that
spelling it correctly in the properties
table - and that there are no spaces or other
punctuation in either occurance of the name.
I don't know, why still error?

I don't know either. As you've seen in my example, this works fine.

I didn't see the original post but to use RowSource you just identify a string
that represents the address of the cells (see the help file, that's what it says
too). Attached is a .xls file with a simple form  with one combobox and one
listbox. Both have RowSource set to "TestData" which is a column of data on a
worksheet. If you're doing this in VBA instead of writing the name TestData
directly in the properties dialog then you need to include quotes around the
name.

The title of this thread is VLOOKUP but since the latest question is about
RowSource, I answered it based on that.

To use the RowSource to set the data for a combob/listbox you need to
identify it as a string (see the help file, it's quite clear on this).

listbox1.rowsource = "myData"

where "myData" is some named range or an explicit address
like "Sheet4!A4:A10"