Am I correct to say that for the first method , I still have to import the
data from the database into a worksheet, whereas the second method I can make
my data Validation to directly point to the database?

If it is correct, then I will appreciate if you could explain the second
method in more details.

I just want to clarify that what I want is to make a drop down list, where
the source is directly from a MYSQL database, so I dont have to firstly
import the data into a worksheet, and make the data validation to point at
that worksheet.

Thanks a lot


"Bob Phillips" wrote:

Which one?

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"irene c" wrote in message
...
Thanks for your reply. But since I am quite new in excel and VBA, could
you
please explain it in more detail?
Thanks once again.

"Bob Phillips" wrote:

You could have a timed routine, using say Application.Ontime, which
builds a
list on a worksheet and use Data Validation to point at that.

An alternative is to use a combobox from the control toolbox or forms
toolbar, and create a procedures to query the database and populate the
list
dynamically from the recordset.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"irene c" wrote in message
...
Hi, is it possible to create a drop down list which take source of
data
directly from a table in MYSQL database?

Thank you in advance for the help