Greetings
I recently moved over to excel 2016 from 2013. I have a Userform with fields for manual date entry. I would like to use a button the end user can click on and a calandra pops up for date selection, and closes with clicking "X".
Any help is appreciated.
Try here: http://www.rondebruin.nl/win/addins/datepicker.htm
I haven't tried this particular download, but Ron de Bruin's is a reliable site - I've used it for reference quite a lot.
Hope that helps.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you for the information. I did do some research prior to posting here and did come across Rons page. I will look at it again as I don't think it shows me how to use calendar with a Userform.
I'll report back with results.
ok, I downloaded the example file, and the add-in file. I'm afraid this will not work for me as it appears you need to have the add-in file on your machine and launched in addition to the userform in order for things to work. Any one have any other ideas? I should point out I am using excel 2016 and I am learning quickly things have changed a bit compared to previous 2013 version.
The Userform I am working on will be sent to multiple users for use weekly.
Having end users open the add-in file in addition to the Userform will not cut it.
Thanks in advance for your time and feedback.
Last edited by mcvideo; 06-08-2016 at 10:40 PM.
I've done some digging around and it seems that almost all the calendars need add-ins. The only one I can find which runs from VBA only is here: http://sitestory.dk/excel_vba/calendar.htm
The page looks a bit older, but if you download the .zip file, the notes on it were updated at the end of 2015, so it has at least been updated recently. I'm running 2010 and it works ok for me. It doesn't do exactly what you asked for in your first post, but it might be tweak-able to do so.
Not true, You can take the code from the Addins and place that code in your file
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
@Keebellah: Good to know - I can't use add-ins at work (I can't even download most of them), so I've never really investigated them to see how they're built.Originally Posted by Keebellah
@mcvideo: sorry I haven't been of more help. Hopefully Keebellah's advice is more useful.
@mcvideo: I can help you but how far does your VBA knowledge go?
If you could attach a sample file with the userform and macros as you have it now I would like to give it a shot.
AddIns are not that bad you can even have them load when this file is opened and closed the moment you close the workbook, but ... that is a little more VBA
I use this quite often so that I have a number of UDF's at my disposal and not have to copy vba modules into every file.
@Kebellah my VBA knowledge is fairly new as I took a course this past January covering basics to advance coding. I am already using what I have learned and enjoy it. I'll send my example later on in the afternoon. Thanks for the help and collaboration.
I have attached a copy of the user-form and VBA code for the current set up. I would like to add a calendar pop up to each calendar photo icon.
Thanks in advance for your time and collaboration.
attachment added.
any luck with this @Keebellah?
I'll take a look and get back to you.
I used the module I wrote and inserted it in your file:
It consists of the following parts:
DateSelectorForm
DateSelectorModule
DateModuleInternational
Just click the image next to the date filed in your form to trigger it.
Thank you. I will take a look at it and report back.
I wrote code myself, it is not as sophisticated as Ron's AddIn but it does the job
MyCal example image.jpg
@Keeballah Thank you for the working calendar. Much appreciated. Question, when clicking cancel button the following date is inserted. I looked at the code behind the cancel button and did not see anything that would be causing this. Any clue? Thanks in advance.
Yes, that's one of the issues I'm having with the code. You see, when you press cancel the value returned is a null string but because it's a date it's interpreted as 00:00:00 and that is interpreted as before 01-01-1900
I tried this (quick-and-dirty)
Change (replace) the code in the Sound_Userform routine:
I think this should do it
Please Login or Register to view this content.
You can remove the Debug.Print line
@Keebellah I replaced the code and the funky date no longer appears. Issue now is each time I click Commit to insert the date the Cal closes but re-appears again. Same thing when clicking cancel. The Cal closes but opens up again. Clicking cancel 2nd time closed the Cal. I also removed Debug.print line from the code.
Any clue?
Would the attached be of any help? You need to change it to what you need yet.
No it's okay, I found the 'culprit'
You will need to do two things:
Check/Verify the three routines shown below in DateSelectorForm
And then in the Sound_Userform you will have to replcae the Sub with the code belowPlease Login or Register to view this content.
I referenced the DateSelcetorForm in the Format part and that is what triggered the userform a second time.Please Login or Register to view this content.
Just to make sure check the Function below (it's in DateSelectorModule
I'll check out the file you posted, it's a lot more sophisticated, but I like my codePlease Login or Register to view this content.
Sorry, haven't had time to check this but I will and report back..
take your time.
Re: Excel 2016 Userform with pop up calendar
I have DL the program and will see how it does for me. I intend to integrate this into my management system to decrease strokes in data input
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks