LinkBack URL
About LinkBacks
I have created an Excel calendar popup in Excel 2007 and I want to share file with a computer that has Excel 2010 installed. All macros are working except for the calendar popup. Anyone knows how to create Calendar popup in Excel 2010?
I have created an Excel calendar popup in Excel 2007 and I want to share file with a computer that has Excel 2010 installed. All macros are working except for the calendar popup. Anyone knows how to create Calendar popup in Excel 2010?
What kind of calendar did you use in XL2007?
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
This is what I have written in Visual Basic
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim isect As Range
If Target.Cells.Count > 1 Then Exit Sub
Set isect = Intersect(Target, Range("$A$2:$A$1048576"))
If Not isect Is Nothing Then
frmCalendar.Show
End If
End Sub
You can go here to see if this calendar will work for you. You can copy the userform and code over into your workbook and use a command button or something to call the userform up(nevermind, I see that you are using Column A in your worksheet to call it up)....open the attached workbook and see if the calendar works for you before doing too much work.
Last edited by jwright650; 03-23-2011 at 01:18 PM. Reason: added comment
I get error message "Cannot find project or library". Marked is the following:
Private Sub UserForm_Initialize()
ThisDay = Date
Yeah, I get that on some machines, while on others there are no errors....I thought maybe your machine might be one that does OK.Originally Posted by pansovic
I'd love to know what the hangup is...still trying to solve the mystery.
Weird because it runs fine in this file(see attached)...try this one.
I get exactly the same mistake
I don't know....I'm sorry that I wasn't able to help.
I opened it up and used the Scrap Sales 2011.xls before I attached it and it worked for me.
Hopefully someone more knowledable in VBA will chime in and help us figure out why it won't work for you.
See the alternatives here
DatePickers
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I am not sure if this is really practical. For example if you want the short format you always have to double-click and change format. Seems like there is no configuration that you always have the short format. Neither can you work with the date as TODAY(), etc. I have yet not tried it on Excel 2010. Will do that tomorrow
Ok, here is my last ditch effort. I'm out of ideas. I used one of royUk's UserForm Calendars in this file....see if this could work for you.
I have exact the same problem. Thanks for the effort though no solution yet.
Excel 2010 does not come with a calendar control. The "can't find project..." error is caused by missing references -in this case probably the calendar control!
Everyone who confuses correlation and causation ends up dead.
What I posted in post#11 works on my XL2010 here at home.
Yes - that's not a Calendar control.
My point was to explain why the problems were occurring.
RS, yes I understood the intent of your post. I was just stating that for the OP.
Is the calendar build that I was using in post#6 a calendar control?....I thought it was using code to build the calendar...creating the form and building the buttons and everything appeared to be done by code.
EDIt: that file in post #6 opens fine on this XL2010 also
Last edited by jwright650; 03-23-2011 at 07:40 PM. Reason: added comment
I couldn't tell you at the moment - I'm posting from my phone.
Ahhhh, technology on the go...LOL
Figured out something this morning....try these two files and see if you can use the calendar in them. Rev2 has royUK's calendar in it....Rev3 has the calendar build that I've been using.
Both are working in Excel 2007 and 2010. Though now I will need the same when I click on a cell that automatically opens me the calendar. If possible I as well prefer a calendar that moves to other month with 1 click at right or left of calendar and not thyat I have to pinch first year, month and date.
Hi all, is this thread still active???
I am wondering how, when you select the date from the userform (in "Scrap Sales" example), to get that date to paste into a cell?
Cheers
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks