calendar vba

Due to a problem I have in my work regarding the installation of software and add-ons, I was unable to install the reference "Microsoft Windows Common Controls 6.0 (SP6)" to use the activex calendar control. So I created this simple calendar and I will share it here on the forum in case anyone...

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...

I'm trying to create a data collection tool in a research study that will only provide the last 30 calendar days from the date it is opened. I'm using Excel Calendar, and I put the information for the date ranges in two cells on the side of the calendar, where the 30-day period start date is L4...

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...

Hello, I have a problem that I have not been able to find any help on. I have spreadsheets that has 31 columns to account for each day of the every month. Each column has about 17 rows in them. I would like to be able to enter a specific day or range of days such as monday thru Friday, or...

Hi, I'm looking to implement a rule so that when a specific resource is selected for an assignment, a check is done through the existing data to see whether they are already 'booked' for work within that calendar period. I've put together an example here...

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...

Hi I am using the following code behid a simple spreadsheet which I need to enter two different date values (in 2 different columns). However the code only seems to work in 1 column (column 'M') but I would like it to work in columns 'M' and 'R'. Any idea on how to amend the code please...

Hi, I created a very basic routine that utilizes a basic form setup with the activation of the calendar object. My VBA code is stored as a public sub routine on sheet 1, where when a user clicks on any cell in columns A, B or C from any row greater than 25, a calendar pops up and upon the user...

So I have been researching this issue for days and I have to say I am stumped. What I am trying to do is put together a perpetual Calendar that is it's own worksheet that can change month to month and year to year. I have been successful building the Calendar and many other upgrades with out...