See if this helps...
http://vbaexpress.com/kb/getarticle.php?kb_id=600

Look for this comment in the code:
'Define the list and where it's obtained from (Columns A, D, G in this example)