Register
Log In
Unanswered
Home
New Member
June 27, 2016
Offline
I am trying to add a calendar control in an Excel spreadsheet. I have "Googled" it but when I try and execute my spreadsheet keeps shutting down on me or becomes non-responsive.
Can anyone guide me to a good resource for doing this.
Thanks
Rob
October 5, 2010
Offline
Hi Rob,
Can you supply a file so we can look at what you have done?
You can check this blog post which shows how to use a calendar in a form to enter a date in a cell
Phil
New Member
June 27, 2016
Offline
Dear Phil,
I have attached the Excel file which I am having trouble with. I would like to add a calendar control in columns C and D and drag it down to row 50.
As you can see the file is very slow to respond. My code that I put into VB is no longer in the file as I removed it due to the performance I was receiving.
I really appreciate the assistance, and will definitely check out the link you suggested.
Regards,
RobÂ
October 5, 2010
Offline
Hi Rob,
there's no file attached. After you click on 'Add files' you also need to click on 'Start Upload'.
So what is it you are trying to achieve? You want cells C1:C50 and D1:D50 to contain a date picker? That is, if you click on one of those cells, you get a calendar/date picker which allows you to choose a date which is then entered into that cell?
Phil
Most Users Ever Online: 57
Currently Online: azri adrin, Mark Lund, Rudi
24 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Joy Berryhill
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
