if todays date is in the month of january, then specific drop down list, if feb, another list, etc
 

This is what I am wanting to do: When the worksheet is opened, I have
the form =Today() in a hidden cell. If that date contains the month
of January, I want a specific drop down list to appear in another cell
(H4). If it contains February, another list should appear in that
same cell (H4). If March, another list, etc throughout the months of
the year.

I had orig trid to do a user form calendar, but this sheet will be
used by over 30 people throughout 8 different offices and not all of
them have the control installed.

Please help??

if todays date is in the month of january, then specific drop downlist, if feb, another list, etc
 

I'm don't see how a calendar control will help.

Maybe you could use Data|Validation and use dependent lists.

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

I'd create 12 different named ranges that hold the list for that month:

Month_Jan
Month_Feb
....
Month_Dec

(Use insert|name|define to create these names.)

Then I'd use data|validation for the cell that should show the different lists:

Select the cell
data|validation
On the Settings Tab:
Allow: List
Source: =INDIRECT("Month_"&TEXT(TODAY(),"mmm"))

If you need more than 12 lists (Jan 2007 is different from jan 2008), then make
as many defined names/lists as you need and modify the source:

=INDIRECT("Month_"&TEXT(TODAY(),"yyyymmm"))
if you used names like: Month_2007Jan


bjohnson wrote:

This is what I am wanting to do: When the worksheet is opened, I have
the form =Today() in a hidden cell. If that date contains the month
of January, I want a specific drop down list to appear in another cell
(H4). If it contains February, another list should appear in that
same cell (H4). If March, another list, etc throughout the months of
the year.

I had orig trid to do a user form calendar, but this sheet will be
used by over 30 people throughout 8 different offices and not all of
them have the control installed.

Please help??

--

Dave Peterson