Excel Programming

[Geoff D'Arcy]

I need some help with a workbookI am making. I am fairly capable of most
excel uses, however I am working from someone else's sheet which has a lot
of protected cells and I would like to simply make my own that looks the
same. But I like how he did his "drop down menu" to change the date, so I
need to know how to go about doing that? Would someone have the time to
look over this file and give me an idea how I can recreate this? Thanks.

Geoff

 

[Melker Sandberg]

Hi,

Are you sure that you need VBA for that ?
If you only need a drop down list i would use Validation and then perhaps a
lookup formula to retrive the data.

http://www.exceltip.com/excel_tips/Lookup_Formulas/112.html

/Melker

 

[Tom Ogilvy]

Drop downs can be created by selecting the cell and doing

Data=>Validation then select the list option and specify the location of
the list to show in the dropdown.