Refer this link

http://www.mrexcel.com/articles/excel-user-forms.php
--
If this post helps click Yes
---------------
Jacob Skaria


"Eddy Stan" wrote:

Hi Any help for a pull down list (validation)

can the names of active workbooks be listed with a pull down list at b5 in
the active sheet called "Form 1"

the list needs to be stored in active workbook, sheet name called "archive"
from range c3 onwards.. like c3,c4,c5... each file name in following cells
from c3.

i have some related work, like using the sheet name at c5
some report has to be shown below.

thank you.