Hi Guys,

I know nothing about excel macros so I am looking for good help. I want to
know how to refresh my drop down boxes (data validation, not combo boxes) in
a excel spreadsheet whenever the workbook is opened. ALso, I want to
populate 5 cells on the dropdown worksheet with data from another worksheet
depending on what i choose in my drop down box. Any help and examples would
be greatly appreciated. I am used to Access and I can't seem to figure out
how create events, functions, subs, etc.
--

Thanks in advance,
Matt
(access 2000)