How to insert date using a pop up calendar control in a cell in E.

It has to be simple to add a control to an excel worksheet so when a user 
clicks on a cell a calendar pops up allowing the selection of a date.

I just can't figure out how to do it.
0
sinned81 (1)
11/12/2004 4:54:34 PM
excel.misc 78881 articles. 5 followers. Follow

7 Replies
531 Views

Similar Articles

[PageSpeed] 27

1. View..ToolBars...Control Toolbox
2. Click the button for More controls (looks like two hammers)
3.  From the list Select "Microsoft Date Time Picker "
4.  Drag on sheet for the size of the control
5.  Turn off design mode (green triangle on the control toolbox) to use the 
DT control



"sinned81" wrote:

> It has to be simple to add a control to an excel worksheet so when a user 
> clicks on a cell a calendar pops up allowing the selection of a date.
> 
> I just can't figure out how to do it.
0
Hayeso (14)
11/12/2004 4:54:30 PM
Hi
see:
http://www.rondebruin.nl/calendar.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"sinned81" <sinned81@discussions.microsoft.com> schrieb im Newsbeitrag
news:CBBB7926-9B48-4B08-B2C4-A3FBE23AA200@microsoft.com...
> It has to be simple to add a control to an excel worksheet so when a
user
> clicks on a cell a calendar pops up allowing the selection of a date.
>
> I just can't figure out how to do it.

0
frank.kabel (11126)
11/12/2004 5:11:55 PM
Ist it possible to link the date reurned from the calender into a formula in 
another cell to perform date maths. If so how can I do it?


"Hayeso" wrote:

> 1. View..ToolBars...Control Toolbox
> 2. Click the button for More controls (looks like two hammers)
> 3.  From the list Select "Microsoft Date Time Picker "
> 4.  Drag on sheet for the size of the control
> 5.  Turn off design mode (green triangle on the control toolbox) to use the 
> DT control
> 
> 
> 
> "sinned81" wrote:
> 
> > It has to be simple to add a control to an excel worksheet so when a user 
> > clicks on a cell a calendar pops up allowing the selection of a date.
> > 
> > I just can't figure out how to do it.
0
Scout (3)
2/23/2005 1:45:01 PM
hi..  under more controls, i do not have a selection called "microsoft date 
time picker"..  i am using excell ver 2003

"Iain the scout" wrote:

> Ist it possible to link the date reurned from the calender into a formula in 
> another cell to perform date maths. If so how can I do it?
> 
> 
> "Hayeso" wrote:
> 
> > 1. View..ToolBars...Control Toolbox
> > 2. Click the button for More controls (looks like two hammers)
> > 3.  From the list Select "Microsoft Date Time Picker "
> > 4.  Drag on sheet for the size of the control
> > 5.  Turn off design mode (green triangle on the control toolbox) to use the 
> > DT control
> > 
> > 
> > 
> > "sinned81" wrote:
> > 
> > > It has to be simple to add a control to an excel worksheet so when a user 
> > > clicks on a cell a calendar pops up allowing the selection of a date.
> > > 
> > > I just can't figure out how to do it.
0
Blair1 (12)
6/15/2005 7:03:14 PM
Hi

Check out this free in cell datepicker.


http://www.isamrad.com/excelcal/

HTH

Ken


0
KenMacksey (98)
6/15/2005 8:43:29 PM
The ms datepicker is part of the ms common controls ocx (MSCOMCT2.OCX) 
usually found in the windows\system or windows\system32 folder.

Ken 


0
KenMacksey (98)
6/15/2005 8:46:44 PM
Hi Ken,

is it possible to get these controls ?  I did a search and I get the 
impression you need Visual Basic.  I simply would like to have these controls 
to use in Excel.

thank you

Pierre

"Ken Macksey" wrote:

> The ms datepicker is part of the ms common controls ocx (MSCOMCT2.OCX) 
> usually found in the windows\system or windows\system32 folder.
> 
> Ken 
> 
> 
> 
0
Pierre1 (23)
12/17/2005 8:10:02 PM
Reply:

Similar Artilces:

Standard MFC controls behave different when showing polish characters
Hello all, I have a rather simple to describe but difficult to solve problem. Our customers want to use our ANSI MFC program to show different languages. For example Polish. When I set the font for the different controls they behave different. For example the CEdit shows the polish characters just right but the CButton with checkbox style shows glyphs instead of the special characters. Every control that is owner draw and uses for example the DrawText() function of the device context shows the characters right. I've experimented with _UNICODE for the display part and everything I could ...

Inserting form values into a table
We have a form with values taken from an sql query that comes from two different tables. We would like to enter the information into a third table. Can some one direct me to code that will do the following: 1. Provide the Insert sql that shows us how to add the form values to the table 2. Show us how to loop while inserting the information into the table (there could be several lines on the form, each must be inserted one at a time). I have worked with Access before and have never had a problem inserting information. However, I cannot quite figure out how to insert informtion through an ...

Using expression builder object
Hi, I'm developing a wizzard in Access which builds import templates for various data sources to a fixed set of tables. In step 3 the users must be able to build an expression ; for instance Left([Fieldx],20) . Now I would like to have a command button on my form which calls the Access expression builder to allow the users to use this to build the expression. This expression will then be stored in a text box linked to the templates table. Anybody know how to call and use this object from VBA code? -- Kind regards Noëlla DoCmd.RunCommand acCmdInvokeBuilder I th...

move cell contents
Is there a way to move a cell contents to another cell with a formula. ex: if a5="Name" then move g5 to j5? Also, I am using =INDEX(Sheet1!B3:B12,INT((RAND()*10)+1),1) to pick random names from a list. I have the formula in different place pick random names from different list. This does work, but I have different list with some of the same names and with the random pick I do not want the same name to appear. -- Thanks for any and all help. Davidl Hi David a formula can only affect the cell it is in, it can't move or change another cell for this you need some code ...

Administrative Groups
I have 2 Administrative groups with a Exchange 2003 Server in each group. One group is on the other side of campus and is controlled by their Exchange Server Tech. I have delegated control of my server to myself. There are also users from the other server that do not belong in my server and would like to remove them. The problem is, that when I go to remove them it will not , because the user or group is inherited from the organization. How can I remove them from my server and yet not remove them from their server? It sounds like that if I remove them from the orgainization that they wi...

Using part of a cell in a chart title
I have a chart which should get a title. However, this should be partly be used from a cell e.g. "counted with 5%" 5% should be taken from the cell and used in the title. Is this possible? Hi, Yes it's possible but all of the chart title needs to be in the cell. So you may need to use a helper cell and concatenate text and value. http://www.andypope.info/tips/tip001.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nicole" <Nicole@discussions.microsoft.com> wrote in message news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@micro...

visible cell only
I'd like to use the PERCENTILE function in a list that has been autofiltered and get the results based only on the visible cells. I've used SUBTOTAL in order to get count, average, min and max. But I need to get the .25 and .75 percentile figures for the filtered data (visible cells only). I've scoured these forums. I've scoured the web. I've found some vba code that was supposed to select only visible cells but it doesn't work for me. I posted last week in the programming section of these forums (and again this morning) but got no reply. I figure...

Input Excel 'Password to Open' through control in access form
Hi All, We know,Excel has prompt password to open it files. Is it possible to create a code that can supplies the excel prompt password?.So that when we open the excel file through our access control in a form, the excel files can be opened automatically.But when the excel files opened from its default icon,it will prompt a password first. ...

Auto start (and Stop) downloading from POP accounts.
Sir, My ISP rpovide me a free time to use internet conection between 2.00 amto 8.00 am. My ISP charges me on the maount of data send / receive by me on MB basis. So, is any way that the MS profesionsl edition 2003 (outlook) starts on 2.01 am, starts downloding / sending the mails from POP accounts. and stop at 7.59 am. Is any trick available , please let me and other esteem members of this group know. thanks in advance. Schedule a task (in Win), ie to start OL (I assume you will have configured OL for polling) Then schedule a shutdown/close of OL "Prince" <r.r.makwana@gmai...

Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week and make it a recurrence with no end date. Can I set this up once in Outlook so it is scheduled automatically? -- Microsoft Office 2003 Version Students and Teachers Edition Windows Vista Home Premium Thank-you Happy new Year!! Carl R ...

Filter recordset using query results
Hi all I have a form based on a query called [qry Quarterly Planning], it lists all Itineraries on the system. On this form you can filter records by specifying a Start and End Date for the [ReviewDate] and/or [Specialist]. It is a subform on a main unbound form, lets call this Subform1. Along side this I have another subform (Subform2) which displays ReviewDates that exist against an Itinerary. In other words Subform1 has a start date of an activity and if the activity lasts longer than 1 day, then the additional dates are stored in Subform2 (ItineraryDates). Currently when I...

How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?
Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change the default Style for e-mails from 'Normal' to 'Normal (Web)'. The problem is that new e-mails and replies in HTML format use the 'Normal' Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of this is that when sending an e-mail, I have to press return twice to create a gap, but when the recipient views this, their software shows it as four gaps (the extra carriage return I typed + their correctly viewed HTML carriage return after each line). E.g. I type this: ...

Drag and Drop file/directory names on Tree Control.
hi, I am writing an application in which i have one Tree control. Now i want that , when user drag & drop any file/folder on tree control the file name/folder name should be add in the tree control item. User may drag and drop file from desktop or may be from directory. I just want the path of that file/foder name nothing else. so plz tell me will it be possible ... Plz Help me............. Klic..... > I am writing an application in which i have one Tree control. >Now i want that , when user drag & drop any file/folder on tree >control the file nam...

How do I use traffic lights in excel
I am wanting to use traffic lights in excel that change colour based on the result of a variance cell, ie if the result of the cell is 10 make the traffic light green, if it is 20 make the traffic light amber, if the result is 30 make the traffic light red. How do I do this? Shorty Format>Conditional Formatting>Cell Value is: Note: you can add up to 3 conditions(4 if you count default) Gord Dibben Excel MVP On Wed, 22 Dec 2004 16:35:03 -0800, Shorty <Shorty@discussions.microsoft.com> wrote: >I am wanting to use traffic lights in excel that change colour based on the &g...

what's the formula for adding symbols in cells?
I have a chart that has blank info in the legend. I want to add an * to indicate something, but just inserting a symbol doesn't work. Any ideas? Thanks. Debi - To add information to the legend, you need to add to a series name. Right click on the chart, select Source Data from the pop up menu, click on the series tab, select a series, and either type something in the name box, or click in it and select a cell with the mouse. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Debi wrote: > I have a chart tha...

How do I merge cells with multiple data values?
I've tried highlighting the two cells which are in the same row. It suggested that I format and align. Both of which I've tried. I keep getting the same error message, "The selection contains multiple data values. Merging into one cell will keep the upper-most data only." I need to make the cells one with all my information. Is this possible? Not knowing what you want to do, let me make a suggestion. Put all your data into the first cell and leave the second cell empty. Select both cells. Click on Format - Cells - Alignment tab. In the "Horizontal" b...

dates #5
Is there a formula to ad a numeric value to the name of a month. I am running a query in excel (pulling from an external source) and would like to sort as teh table refreshes by month and year. I have code to to do the refresh and the sort, but it sorts in alphabetical order. I was thinking a formula could place a numeric value to the month (1 = Jan, 2 = Feb, etc) and I can sort based on that. Is there an easy formula to do this. Thanks in advance Your easy formula could be: =MATCH(A1,{"Jan","Feb","Mar","Apr","May","Jun"...

Using Visio HTML output within frames
Hi, I want to include visio HTML output in a frame of another html file. Unfortunately it is not working. I understood the problem is in vml_*.htm files. It is due to, the target arrtibute(pointing to _parent) in v:shapetype tag and href attribute (pointing to #) in v:shape tag. These attributes should point to "_top" and "<target-html-file>#" respectively inorder to work. I want to change these options while saving .vsd as web page? I would appreciate if you can help me in this regard. <v:shapetype id="VISSHAPE" target="_parent" coor...

why are links to websites (inserted in publisher documents) disab.
why are links to websites and e-mailadresses (inserted in publisher documents) still working in emailpreview but disabled in webpage preview? ...

Can you only merge up to a certain number of cells
I am working on microsoft excel 2003, I have a sheet that I merged cells starting with line 8 through 43...when I type my information in the merged area I can see all that I am typing...say it goes up to line 30 once I hit the enter key I can only see up to line 20. Even when I print it out it only prints up to line 20...I have checked to make sure there are not locked cells etc. I cannot figure out at all why this is happening...is there only up to a certain number of cells you can merge? From "Excel Specifications and Limits" Length of cell contents (text) ...

Convert date
How can I convert a date in this format (mm-dd-yyyy) to a Julian-date (i.e., YYYYDDD)? For example: 09-13-2003 to 2003256 Hi see: http://www.cpearson.com/excel/jdates.htm -- Regards Frank Kabel Frankfurt, Germany gary wrote: > How can I convert a date in this format (mm-dd-yyyy) to a > Julian-date (i.e., YYYYDDD)? > > For example: 09-13-2003 to 2003256 On Wed, 8 Sep 2004 10:24:57 -0700, "gary" <anonymous@discussions.microsoft.com> wrote: >How can I convert a date in this format (mm-dd-yyyy) to a >Julian-date (i.e., YYYYDDD)? > >For exa...

formating date from general2 custom
I have an input xls file with the date but like this: Wed May 14 00:00:00 GMT-05:00 2008 I need to have just following format dd/mm/yyyy I tried to format it using Format->Cells->Date or Format->Cells- >Custom but this is failing. Nothing changed. Any ideas? Thanks for the help. Vlad <vladimir.vaynshtok@gmail.com> wrote in message news:1013b138-352b-4799-81ba-9508b74a1850@t54g2000hsg.googlegroups.com... >I have an input xls file with the date but like this: > > Wed May 14 00:00:00 GMT-05:00 2008 > > I need to have just following format > > d...

Font dosen't revert back to original after typing in date
Example I n my text I type I have December 28th The th automatically reduces to a much smaller font and once you hit the sapce bar to continue it reverts back to the larger font. It only does this some of times, why is this being so inconsistent?. I refortmated my comp. last week and when I reinstalled office I was hoping this inconsistent problem would have been resloved, but no 2nd question please. When I post a question in "discussion group" and check the box "Notify me of Replies" I never receice a reply to my question I then have to go back to ...

Pop Up Windows
Several sites pop up smaller windows with advertising. The opop up blocker does not stop these smaller ad windows. How do I stop them? -- Larry "Larry" <Larry@discussions.microsoft.com> wrote in message news:C0B01C98-66BF-4FA5-8CED-0C434CCCFC62@microsoft.com... > Several sites pop up smaller windows with advertising. The opop up blocker > does not stop these smaller ad windows. How do I stop them? > -- > Larry You don't. They LOOK like a pop up to you, but the designer that wrote the page made them not conform to the rules that define the...

Newbie Question: Using Web Services
Hello All. I've been trying to implement Infopath with CRM with no success. I've tried the example, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmbscrm1_2/html/mbs_crminfopathcrmintegration.asp, to no avail. I have followed the example to the letter, but find the information about publishing the Web Service to the server to be somewhat lacking. Admittedly, I am not a programmer, and I am continually running into an error in line 54: xmlDoc.LoadXml(objQuery.ExecuteQuery(objBizUser.WhoAmI(), strAllAccountsFetchXML)); Has anyone else ...