calendar control

  1. J

    Interactive Calendar for Daily Reports

    Hi, I want an easy way to access daily reports using a calendar as a dashboard. I have already created the calendar in Excel which runs from 2018 and 5 further years to future proof the document. On a separate tab I have created the Hyperlinks for every daily report for the next 5 years so that...
  2. A

    Populate Text from tracking sheet onto 3 different calendars sheets

    New here! But I need some help automating data within an excel sheet. The attached sheet contains 5 tabs. First tab is a tracking sheet, second tab is a US calendar, third tab is a CA calendar, fourth tab is an AU calendar and the final tab is a list sheet for reference. Using the tracking...
  3. L

    A way for make a calendar

    Hi guys! I share this file here, it's a simple way to make a calendar. Download: https://drive.google.com/file/d/1BEDJLLdUajUiqh7rwwW3iUCDg1FJjOjA/view?usp=drivesdk I use simple functions and creativity. The loop does the opposite way of what I believe would be conventional. When dealing...
  4. I

    Pop-up Calendar to choose and display multiple dates

    How will you use a calendar or month view user form for this one? here are my steps: 1. when the active cell is in column B, a calendar will pop-up 2. From the calendar, i will choose multiple dates and hit OK button or ENTER in my keyboard*If I hit the ESC button on my keyboard, calendar will...
  5. A

    Date calculations in Excel 2016 VBA

    ' The following block of code calculates the service user's age and turns on the 'Child' radio button _ if the service user is under 18 years of age. ' This works fine in Excel 2007 but crashes out in Excel 2016 with a compile error (can't find project or library) on the highlighted line. '...
  6. R

    Calendar error in another PC Macros

    Hi, I've made a program using Calendar Controls on excel 2007, and it's running perfectly in my PC, but when I send the file to a coworker with the same excel version it displays a compile error and highlights the Calendar.Value command, and when I click on design mode on my partner's PC the...
  7. S

    userform calendar in excel 2013

    hello again, I have below questions with which I need help/suggestions please. 1. A userform created in excel 2007 which has calendar control option in additional controls - will this work as it is if system having 2013 on it? 2. How do I get Calendar control in 2013? If not, the code? 3. I...
  8. Grizlore

    Suggestions for the most elegant solution for inserting dates into a Userform (avoid Calendar Controls)

    Hi All, (Happy New Year!) I wish to totally avoid the use of Calendar controls, as I have experienced many issues with them as I need to provide a solution for Users who use several different versions of Excel. I have a Userform which needs two dates. The first is normally the current date...
  9. A

    Send lotus reminder based on date table in excel

    Dear All Excel Experts...I need your immediate help...its been years together I am not getting any help on Lotus Calendar and excel integration.. I am working on a MOM. MOM have certain items need to be completed by certain dates. Many of the times I miss the action item deadline. I wish to...
  10. B

    Popup Calendar Tool for excel 2013

    I'm trying to find an OCX file or something that replaced the DateTimePicker / Common Controls ver 6 (mscomclt2.ocx) to use in Excel? I've tried to load the older version, but it doesn't work.
  11. Prevost

    Display current date on excel calendar

    Hi There, I have read some posts but I am still unsure about this. I have a macro on my sheet that runs whenever I double click certain cells. The calendar pops up and I can select a date from that calendar. Now I know that the calendar date defaults to whenever the calendar was created...
  12. L

    Help making an availability calendar/booking calendar

    Hi All, This is is my first post. i would like to create a calendar that can be used on my website to show open or available spots. On Fridays, Saturdays and Sundays only, we have up to 10 available spots, per day. If possible, I would like to be able to go in on the back end and perhaps...
  13. R

    Loop when Calendar Selected

    Hi... I entered code In my UserForm1 to pop up a calendar when TextBox18 is double clicked. Private Sub TextBox18_DblClick(ByVal Cancel As MSForms.ReturnBoolean) UserForm3.Show TextBox18.Value = DateValueText End Sub The code for my calendar is: Private Sub Calendar1_Click()...
  14. R

    Using Calendar Control 12.0

    I have inserted Calendar Control 12.0 in to a userform and would like to have the results go into to a test box, located on the same userform. I have tried using the following code to have the selection from the calendar control placed in the textbox: Private Sub Calendar1_Click()...
  15. T

    Calendar Control By Excel vbe

    Can I contral like this??? by excel vbe... or control like this???
  16. already

    Date Picker in 2010

    Hi I just did the upgrade from excel 2007 to 2010 and saw that the calendar control was not supported anymore by office 2010. I found the free wincalendar tool but it is not exact what I want. Any suggestion to replace the old calendar.ocx is welcom. Thanks in advance Al
  17. S

    Excwl 2003 - VBA - Zoom & Calendar Object

    Hi, I would lie to know how I can link my calendar object size to the zoom function located on my toolbar. Example , if the use changes the zoom from 100 to 50 then my calendar object size will resize accordingly... thanks !
  18. S

    Date/Time/Calendar Control to work in multi Excel platforms (2003/2007/2010)?

    Need a Date/Time/Calendar Control to work in multi Excel platforms (2003/2007/2010) please... So... I have several spreadsheets created using Excel 2007 with 'Calendar Control 12.0' controls in them. It wont work in Excel 2010 as that control was removed from Office 2010!!! Now... I also...
  19. N

    Pop Up Calendar Help

    Hi, Does anybody know when I add a pop up calendar on a user form, I am able to choose the date and have the textbox filled while using the mouse, but when using the Arrow keys I can move around from date to date, but I cannot make a selection when I hit the 'Enter' key. Does anybody have a fix...
  20. G

    Calender control 12 size changes

    Hi I was wondering if anyone could help me a problem, I have created an Expenditure sheet showing my monthly bills. I have placed a calender Object on the sheet. I have reduced it to a certain size so it fits in a certain position, and in design mode it fits but when I come out of design...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top