Hello every body, I am unable to use this function in excell work book,whether it is possible? I am dont know about VBA,Please helpm of using this TIP,
Regards On Tue, Aug 11, 2009 at 1:27 PM, ankur <ankurpande...@gmail.com> wrote: > > hello friends > i dont know much about vba > i had bring calender to my sheet, but don't know how to proceed > further,can anybody guide me > i had written the code > my query is how to insert the date by using calendar, i can see only > embedded calendar on my sheet > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Tue, Aug 11, 2009 at 11:24 AM, Iqbal Shaikh<iqbal.sw...@gmail.com> > wrote: > > Dear Deepak, > > > > > > Thanks a ton !! > > > > > > > > > > Iqbal > > > > > > On 8/11/09, Deepak Rai <daksh1...@gmail.com> wrote: > >> > >> Hi, > >> > >> In the Developer Tools click on More Controls & then select Calender > >> Control 12.0. > >> Please follow the below steps to get the Calender Control: > >> > >> 1. Right Click on Menu Bar > >> 2. Select "Customize Quick Access Toolbar.." > >> 3. Select Customize option > >> 4. In the Choose commands from drop down > >> 5. Select Developer Tab > >> 6. Select Insert Controls option > >> 7. Don't forget to select the option "Show Quick Access Toolbar below > the > >> Ribbon" > >> > >> Hope this will help you. > >> > >> Regards, > >> > >> Deepak Rai > >> > >> > >> On Mon, Aug 10, 2009 at 1:38 PM, Iqbal Shaikh <iqbal.sw...@gmail.com> > >> wrote: > >>> > >>> Hi ALL. > >>> > >>> How to use this calender in XL 2007. > >>> > >>> > >>> > >>> > >>> Iqbal Shaikh > >>> > >>> > >>> On 8/7/09, Ayushj <jainayus...@gmail.com> wrote: > >>>> > >>>> Hi Shafiq, > >>>> > >>>> This is the awesome tip. Appreciate your knowledge. :) > >>>> regards, > >>>> Ayush Jain > >>>> > >>>> On Aug 7, 3:48 pm, shafiq online <shafiq_onl...@hotmail.com> wrote: > >>>> > Dear All, > >>>> > > >>>> > Here is a tip for pop up calendar in Excel. You can display a > clander > >>>> > in a excel sheet and enter date in a cell by slecting the > appropriate date. > >>>> > Steps are given below; > >>>> > > >>>> > 1. Open excel work book. > >>>> > > >>>> > 2. go to wiew>Toolbars>Controll Toolbox > >>>> > > >>>> > 3. Now u can see a toolbox window in the sheet. Go to last button > >>>> > (more controll) and clink on it. Here u can see a list of controls, > click on > >>>> > Calendar control 11.0 > >>>> > > >>>> > 4. Adjust the clander in the sheet where you required to be diplayed > >>>> > this. > >>>> > > >>>> > 5. Important steps. Double click on calender or right click, then > view > >>>> > code following code will diplay > >>>> > > >>>> > Private Sub Calendar1_Click() > >>>> > > >>>> > End Sub > >>>> > > >>>> > 6. Enter following lind between 1st and last line > >>>> > > >>>> > ActiveCell.Value = Calendar1.Value > >>>> > > >>>> > 7. Your code will look like this > >>>> > > >>>> > Private Sub Calendar1_Click() > >>>> > ActiveCell.Value = Calendar1.Value > >>>> > End Sub > >>>> > > >>>> > 8. Get out of VBA and go to excel sheet and use the calender. > >>>> > > >>>> > Regards, > >>>> > > >>>> > _________________________________________________________________ > >>>> > Share your memories online with anyone you > >>>> > want. > http://www.microsoft.com/middleeast/windows/windowslive/products/phot... > >> > >> > >> -- > >> Thanks, > >> > >> Deepak Rai > >> > > > > > > > > -- > > > > > > > > > > > > Iqbal Shaikh > > > > > > > > > -- Thanks & Regards Shivashankar.C.Katageri. --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
