Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use first day of month formula in a drop down list | Excel Discussion (Misc queries) | |||
VLOOKUP specific data for month required via dropdown list | Excel Worksheet Functions | |||
using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
how to make excel select todays date from a list | Excel Worksheet Functions |