drop down calendar #4

In a cell I want to have a drop down calendar of the current month. I 
downloaded a template of a calendar and tried data valadation but it only 
displayed the source range. Any ideas?
TIA

0
RayA (96)
12/12/2005 9:05:53 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
1058 Views

Similar Articles

[PageSpeed] 13

 
http://www.windowsdevcenter.com/pub/a/windows/2004/04/27/excelhacks.html


"Ray A" wrote:

> In a cell I want to have a drop down calendar of the current month. I 
> downloaded a template of a calendar and tried data valadation but it only 
> displayed the source range. Any ideas?
> TIA
> 
0
Search33 (27)
12/12/2005 9:17:03 PM
Ray

See Ron de Bruin's site for this.

http://www.rondebruin.nl/calendar.htm


Gord Dibben Excel MVP


On Mon, 12 Dec 2005 13:05:53 -0800, "Ray A" <RayA@discussions.microsoft.com>
wrote:

>In a cell I want to have a drop down calendar of the current month. I 
>downloaded a template of a calendar and tried data valadation but it only 
>displayed the source range. Any ideas?
>TIA
0
Gord
12/12/2005 9:43:33 PM
Reply:

Similar Artilces:

Calendar Work Week
Is it possible to have more than 1 calendar with each having a different setting for the calendar work week? For example: 1 to display as Fri - Thurs and another Sun - Sat... (Outlook 2007) Thank you... -- J.T. Kiser No. The setting is global. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outlooktips.net EMO - a weekly newsletter about Outlook and Exchange: mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH....

Drop Down List #9
I am trying to create a drop down list using two worksheets. How would I create this. One sheet would where the final product is and the other would be where the data is being kept. Watch this 5 min video: How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "Vincent Kerzman" <Vincent Kerzman@discussions.microsoft.com> wrote in message news:B2DAA48B-0BD2-4932-AE91-B86D55B8D8A6@microsoft.com... >I am trying to create a drop down list using two worksheets. How would I > create this. > > One s...

Drag and drop of eMail to own application
Hi everybody, i like to drag and drop an eMail of Outlook ( Express & Xp ) and Thunderbird into my own application ( MFC ). There'in the dropped eMail should be readed and the subject, body text, Recepiant, ... should be displayed into textboxes. I can check the different formats of the Drag-Event or Clipboard data. An Outlook Express mail is stored in plaintext into the clipboard, so it's seriously possible to extract it. But with Outlook XP Mails i see only the name of a .eml file ( the of file which would be saved on the Destop for example ) But how to extract the data? Do...

Mailbox Moves #4
Has anyone come across this problem before where you move a mailbox to a designated Exchange database say for instance DB4 then you check the account and it shows it as being on DB1. Does anyone have any ideas about what might be causing this? -- Thanks! Crisoft Two suggestions come to mind: 1. Check event logs for 1007 to confirm the mailbox sucessfully moved. 2. Refresh your ESM or ADUC mmc after the move to be sure you aren't looking at cached data. Other than that it all sounds very strange... -Seth "Crisoft" <ccisat1crc@hotmail.com> wrote in message new...

Conversion #4
How do I convert a worksheet from Word Perfect to Excel? Word Perfect is not a spreadsheet program. -- Don Guillett SalesAid Software donaldb@281.com "Bobby.Montague@fresno.gov" <Bobby.Montague@fresno.gov@discussions.microsoft.com> wrote in message news:E414CB87-6C5F-4B81-844E-1736F5899C64@microsoft.com... > How do I convert a worksheet from Word Perfect to Excel? ...

drag and drop
Using office XP I cannot drag and drop items from one folder to another in outlook 2002. Any ideas? Thanks ...

combine calendars?
How can I combine two calendars on OL 2003? All my data is in the 2nd calendar, but I can't delete to original one. thx LT Hi LT, You should be able to drag and drop all of the items from one calendar to another after changing the calendar view to "By Category." Please follow these steps to copy everything from one to another. 1. Open the calendar you wish to copy from 2. On the menu bar, click View > Arrange By > Current View > By Category 3. Click on the very first item, hold the Shift key down and click on the very last item (this selects all items in the ca...

problem accepting appointment invites for public calendar folder
our computer dept setup a public calendar folder for our dept to record staff holiday etc. the computer dept set it up so that when a member of our staff adds an appointment into their calendar and invites the public folder to the appointment, the request is emailed to the manager (and a tentative appointment shows up in the public calendar). however, when the manager accepts the appointment it enters the appointment into their own calendar. the computer dept doesn't think it is possible to set it up so that it confirms the tentative appointment in the public calendar. anyone know other...

Sum formula #4
Hi Kids of Excel, just a little help please, what formula should i use to add a range o cells up. i have hidden a number of cells and want to add up the range which i shown how do i do this (it can be alot of data sometimes)? Thanks in advanc -- paulu http://www.frontlineuk.co ----------------------------------------------------------------------- pauluk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=520 View this thread: http://www.excelforum.com/showthread.php?threadid=27360 Hi if hidden by a filter try =SUBTOTAL(9,A1:A100) "pauluk" wrote: &...

drop down calendar #4
In a cell I want to have a drop down calendar of the current month. I downloaded a template of a calendar and tried data valadation but it only displayed the source range. Any ideas? TIA http://www.windowsdevcenter.com/pub/a/windows/2004/04/27/excelhacks.html "Ray A" wrote: > In a cell I want to have a drop down calendar of the current month. I > downloaded a template of a calendar and tried data valadation but it only > displayed the source range. Any ideas? > TIA > Ray See Ron de Bruin's site for this. http://www.rondebruin.nl/calendar.htm Gord D...

drop down data want to choose more than one item for cell
I have a drop down box that i want folks to be able to choose more than one item from the box to go into the cell. Multiselect from a DV dropdown is possible using VBA. See Debra Dalgleish's site for a downloadable sample workbook with event code. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. Gord Dibben MS Excel MVP On Fri, 26 Feb 2010 12:40:08 -0800, FranW <FranW@discussions.microsoft.com> wrote: >I have a drop down box that i want folks to be able to choose more than...

Printing Calendar Problems
I have always made small 12 page 4.5 “x 3” wallet-sized calendars in Publisher. Now with XP, when using the calendar wizard in Publisher, I can set the wallet-size up, but it won’t print properly. Usually in the past I would get 4 months per page only using 3 pieces of paper for the entire year of calendars. Now I am only able to print one small monthly calendar per page (12 pieces of paper) with each having the same month printed 4 times on each page. I have looked everywhere for help and cannot figure out why this is happening or how to change it. (Note: I have tried changing the print multi...

Drop Down List #2
Hi All Can this be done, as I am struggling. I have data in sheet B and want to create a drop down list in sheet A from this data, and I can't make it happen, I can create a drop down list in sheet A from data in sheet A but not from sheet B Could anyone help please Cheers Steve Name the range on the other sheet, and you can refer to it in the data validation dialog box. There are instructions here: http://www.contextures.com/xlDataVal01.html Steve wrote: > I have data in sheet B and want to create a drop down list in sheet A from > this data, and I can't make it h...

Calendar updates/synchronization
I have a co-worker who has been able to make a calendar appointment from his home PC and when he gets to work and opens Outlook on his work PC, the appointments automatically upload from his inbox into his calendar. I upgraded his Outlook 2000 to Outlook XP, and now the appointments just sit there in his inbox. I can't find any thing in the knowledge base concerning this, or even how to set up this function. Neither he nor I know who set this feature up for him in the first place. Any help is appreciated. Thanks in advance. ...

Question of drop-down listbox
Hello, Is it possible to have listbox or combobox with Auto HScroll (ES_AUTOHSCROLL) capabilities. Thank You! I don't get it. ES_AUTOHSCROLL is an Edit control style, how would it apply to a listbox or combobox? What are you trying to do? AliR. "Ririko Horvath" <horvathr@securemethods.com> wrote in message news:uHUo%23OyLFHA.3336@TK2MSFTNGP10.phx.gbl... > Hello, > > Is it possible to have listbox or combobox with Auto HScroll > (ES_AUTOHSCROLL) capabilities. > > Thank You! > > I'm soory for not expressing my question properly...

Selecting default calendar view
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Email Client: pop I prefer to have the month view in my calendar, but every day, when first opened, my calendar view needs to be manually reset to Month. <br> How can I select a new default view, and lock it in? On 2/15/10 2:46 PM, jmilty@officeformac.com wrote: > I prefer to have the month view in my calendar, but every day, when > first opened, my calendar view needs to be manually reset to Month. > How can I select a new default view, and lock it in? Entourage should return you to the view you last...

reporting on drop-down values
We created drop-downs and wish to add the values to a report, but of course the extentionbase tables only show the numbers. Is there a specific table where all the actual text values are stored? Hi use the stringmaps table to get the description of picklist values. I hope it helps. -- Singh http://mscrmshop.blogspot.com MSCRM Consultant Orion Enterprise Sydney "TheWkndr" wrote: > We created drop-downs and wish to add the values to a report, but of course > the extentionbase tables only show the numbers. Is there a specific table > where all the actual text values a...

Scheduled reports in CRM 4.0 do not generate snapshots
CRM 4.0 over SQLServer 2005 + CRM Data Connector installed. Able to run reports. Able to schedule report on-demand but no result when I schedule reports to run at a specific time. No snapshots are being generated. Has anyone ever got Report scheduling to work? Thank you! You might want to check to see if the SRS server is configured properly with a valid execution Account. 1. On the SQL SRS server, start the Reporting Services Configuration Manager 2. Check the Execution Account "Younes Aouad" wrote: > CRM 4.0 over SQLServer 2005 + CRM Data Connector installed. > ...

Business Portal 4.0 Users Page Error
Hello: We just completed an upgrade of Business Portal from 3.0 to 4.0. The only issue is that we get a "nuisance" message in the administrator's users page, when we click on a user or modify any BP user settings. The following is the message: An unexpected error has occurred. Please try closing the browser and starting again, or contact your solution specialist. When we click "Details" on the error message, the following appears: System.Exception:soap:Server System:Web.Services.Protocols.EoapException Server unable to process request Microsoft.Applications.B...

Default Calendar view
How do I set the default calendar view? Select one and that should be it. --=81 Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. =20 After furious head scratching, SBC ameritech asked: | How do I set the default calendar view? Thank you for your reply. I select the 7 day view. I then select a single day on the small calender and the 1 day view is displayed. My wife can select any single day and the 5 day view is displayed. "Tis a puzzlement. J "...

Drop user or alias before dropping login
I am trying to delete a user, and I get this error: Login is aliased or mapped to a user in one or more databases. Drop the user or alias before dropping the login. Any advice? Hi Caroline, GO to SQL server --> logins and select the user and open check the properties of the login and see what database access the users has. If any uncheck all the database access and drop the user. Also make sure from the GP front end you have unchecked the company access too. If still you get errors go to each database on the server and make sure they are not in the users list in the databases. ...

Cannot share calendar
Hi I'm trying to setup a user so that she can view someone else's calendar. I have been able to give her access to other peoples calendars, however i can't give her access to one particular user. even though other people can access that particular users calendar. I have given her all the relevent permissions needed to do so in exchange 2000 and at the target machine, but still an error msg of "you do not have sufficiant permisions to view this item" is given. Don't know what else to do....HELP Thank you Don't grant permissions in the Exchange server its...

Help calendar errors!!
I am running WinXP Home and Office 2003 on a Dell Inspiron 5100 with 1gig of ram. All my events have changed, all by themselves, to appointments that span a 24 hour period. Why did my calendar do this and what can I do to keep this from happening again. I had the same problem with Outlook 2000. That is why I upgraded to Office 2003. It takes a long time to change everything back to the way it was before this happened. Thanks, Carole chboise at yahoo dot com chboise@yahoo.snoopy.com to email remove snoopy Have you been changing the Windows System time or changing the Daylight Savin...

Drop down list 04-23-10
How do you display drop down list button even if the cell is not selected? You can't. Perhaps you've seen the button created from a AutoFilter ot PivotTable? -- Best Regards, Luke M "DLB" <DLB@discussions.microsoft.com> wrote in message news:F248BA68-6874-4712-876D-CF2890DD0BF1@microsoft.com... > How do you display drop down list button even if the cell is not selected? Use a combo box from the Forms toolbar. The drop down arrow is always visible. -- Biff Microsoft Excel MVP "DLB" <DLB@discussions.microsoft.com> wro...

TaskPad Hijaks Calendar Overview
Is there any way to prevent the calendar overview from jumping over to the right side of the screen when the TaskPad is enabled? Would be nice if MS introduced floating/dockable screen elements in the next version of Outlook, huh? KZ Ken Zenachon <imafellow@gmail.com> wrote: > Is there any way to prevent the calendar overview from jumping over to > the right side of the screen when the TaskPad is enabled? Of course. Enable the Taskpad, click the bottom of the Date Navigator, and drag it upward to cover the Date Navigator. It will then jump back over to the top of the Navi...