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