I've been following your work over the past 4-5 years or so. You've inspired me so much and just wanted to thank for that! I hope you did not stop producing these videos and more will come in the future!! Thanks again
Thank you so much for your kind words and support! I truly appreciate your continued following and I'm thrilled to hear that I've been able help. Rest assured, I have no plans to stop creating videos. In fact, I have many exciting ideas and content lined up for the future! Stay tuned and keep an eye out for more videos coming your way. Thank you once again for your encouragement and for being a valued fan.
I've been beating my head off my desk trying to get everyone in my group to input dates the same way because Microsoft decided to remove support for their Dtpicker and this is exactly what I was looking for. Liked, subscribed and form submitted. Looking forward to getting this and putting this whole date picker headache behind me.
I found a little bug, if you try to switch only year without switching month (e.g. feb 2021 to feb 2022) you can modify manually the year but to select a day of that same month you have to select an alternative month before then reopen the months list and reselect the orignal one otherwise the list won't disappear. Adding the capability to select the preselected month and an after/before button for years would make this date picker very close to perfection bc writing them slows workflow since they aren't usually that far in selection. (for bills, deadlines etc.) Really just one click to go one year back or ahead. Admirable work anyways, you're fantastic. Subscribed.
This help me a lot may i know what is the project id as i am confused with it since my excel cant install using Microsoft Date and Time Picker Control 6.0 (SP6) and no plugins allowed as well
Man this looks professional.... I am having problems in writing codes that can run on both 32 and 64 bit platforms. I hope tp learn something from you. You're Genius
hi the date picker is one of the most useful for me and I would like to ask whether I can use this in userform as well as on the worksheet in one excel file. Also, it would be great to know how to use the program to convert the dates for real values. Since I use these dates for determining calendar week and I am getting errors because the dates are not real values. P.S. I have tested both date picker in userform and in worksheet and having difficulties in merging both in one excel file. Thank you.
I have a question. The file I received is CellDatePickerX. It works great in a worsheet, but can't get it to work in my form. Is this different than the PopDatePickerX?
@@VBAA2Z I received the version for userforms and it works perfect. I had a form already coded to import data from the selected row, etc. and the date picker worked with no problems. Thank you for this great tool. I can't wait to explore your other projects.
I finally managed to make it work, however now I have a whole new problem. I’ve had to switch to a multipage form and now it will not populate the textbox with the date from the calendar.
Thank you for another great video! I've been following your series for a while now, and there's one problem I cannot fix with user forms. Can you adjust the user form to change it's size and zoom, depending on the user's screen resolution? This is a real issue when you create a userform in high resolution, and send it someone who has a low resolution, the controls would not fit the screen. Do you have any video on this topic by any chance?
Thanks for creating this, I just have a doubt, this will work on tesxtbox associated with a userofrm, what if I want it to work on textbox not associated with a useform(i.e. textbox is placed on a worksheet), what code do I need to modify ?
You're welcome. to write back to textbox in Sheet you can update below code / function to refer to control in Sheet and not in userform ctrlName_SetDate = "dt_start": FormName_SetDate = Me.Name: PopDatePickerX.Show Sub setDate()
Please how can I download the tool I clicked on the link and also searched the tool and also clicked on download a google form appeared and I wrote on the mail and the project ID *028* but i didn't receive anything
Wow this is really awesome, I hope this project can be applicable to Microsoft Access Forms too. Would be really useful as stock date picker in access is really difficult to use and not very intuitive compared to this. Very excited to try it in Access projects. Thanks Sir.
Hi i found the link to download but, the adds and other links are taking other places and i dont see the download after i fill out the form, any help is highly appriciated.
I've been following your work over the past 4-5 years or so. You've inspired me so much and just wanted to thank for that! I hope you did not stop producing these videos and more will come in the future!! Thanks again
Thank you so much for your kind words and support! I truly appreciate your continued following and I'm thrilled to hear that I've been able help. Rest assured, I have no plans to stop creating videos. In fact, I have many exciting ideas and content lined up for the future! Stay tuned and keep an eye out for more videos coming your way. Thank you once again for your encouragement and for being a valued fan.
I've been beating my head off my desk trying to get everyone in my group to input dates the same way because Microsoft decided to remove support for their Dtpicker and this is exactly what I was looking for. Liked, subscribed and form submitted. Looking forward to getting this and putting this whole date picker headache behind me.
Thank you for your support. Please check spam folder too
this is my best VBA youtube chanel
Thanks!
What a wonderful works!!! It's been a long long time since I found a quality VBA channel like yours.
Glad you enjoy it! thanks
Appreciate you for sharing all these useful tools. Keep up the great work.
My pleasure!
Have been looking for this from a long time. Thanks.
Glad to help
Do you download it?
This looks like just the tool I've been searching for! Thank you for your content.
You're very welcome!
I found a little bug, if you try to switch only year without switching month (e.g. feb 2021 to feb 2022) you can modify manually the year but to select a day of that same month you have to select an alternative month before then reopen the months list and reselect the orignal one otherwise the list won't disappear. Adding the capability to select the preselected month and an after/before button for years would make this date picker very close to perfection bc writing them slows workflow since they aren't usually that far in selection. (for bills, deadlines etc.) Really just one click to go one year back or ahead. Admirable work anyways, you're fantastic. Subscribed.
Thanks Satoshi Nakamoto for sharing your observation and for your support. I will review and post back this week.
Just the thing that I have been looking for the past few days. Thanks a lot!
You are welcome!
Exactly what I have been looking for to input dates into a user form
good to hear
Outstanding!!! Excellent👍
One of the best date picker❤️❤️
Thank you kindly!
Superb Buddy, This is what i was searching from long long time.
Great!
This help me a lot may i know what is the project id as i am confused with it since my excel cant install using Microsoft Date and Time Picker Control 6.0 (SP6) and no plugins allowed as well
please download from here pamaitech.com/download
Looks great. Thank you for sharing. Looking forward to being able to download the file and play with it in my user form. Great video as well
Awesome, thank you!
Man this looks professional.... I am having problems in writing codes that can run on both 32 and 64 bit platforms. I hope tp learn something from you. You're Genius
Hope it helps
great tutorials.. looking forward to learn and buy some great tools.. thanks.
Awesome, thank you!
Amazing! Happy to found this channel 🙂
Your videos are so great! I love your style. Thanks so much for your content!
Thank you so much! thanks for watching.
Wow! awesome...gonna implement this on my project. Thanks! VBA A2Z!
Great!
Excellent work done for new to Excel VBA.
Glad you think so! thanks for watching.
Awesome, I love your channel a lot. Hats off
Thank you so much 😀
excellent video and tool. thanks for sharing it freely.
Glad it was helpful!
Excellent datepicker, I thought that the complement for excel 2019 did not exist. Very good contribution.
thanks
This looks good! Looking forward on more users of this.
you're most welcome!
Thank you so much! I have been looking a way to make date picker tool to work in my 64bit but i havent found one.. This is a big help sir!
You are welcome!
Cool popup will be using in my user form!
thanks!
I love this datepickers because thank you so much
Glad you like them!
Very helpful video. thanks for sharing.
Glad it was helpful!
hi
the date picker is one of the most useful for me and I would like to ask whether I can use this in userform as well as on the worksheet in one excel file. Also, it would be great to know how to use the program to convert the dates for real values. Since I use these dates for determining calendar week and I am getting errors because the dates are not real values.
P.S. I have tested both date picker in userform and in worksheet and having difficulties in merging both in one excel file.
Thank you.
Happy to assist if needed.
the values from DatePicker are date. Are you able to share how you're trying to get week number?
How may I try to reach you ?
@@vicsg8621 please find email in video desc
Hi there, the video specificly says is for a form, just though i share this info with you.
This looks like exactly what I needed for a project. Thanks! Great conte.nt
Glad it was helpful!
you made VBA as modern language
Thanks for encouragement.
Amazing Tutorial - Just filled out the google form for it
Thanks Madhuri.
Simplicity is power. Thanx!
You're welcome!
Can I please access the free Date picker as shown in video? Thanks!
Dee, all request processed. Please be sure to check the Spam folder too
hi< thanks for ur time to help but i can't find the download page after filling the form < thanks in advance
please download from here pamaitech.com/downloads/
It's wonderful that you share your knowledge. Thank you so much.
You're most welcome, thanks for watching
Greate job! Thanks for your work!
Thanks for watching!
Very nice calendar looks like a great alternative to the now defunct option embedded in excel
Definitely!
Thank you very much for sharing your knowledge through this sample!
It is very practical and I'm happy with it.
Glad it was helpful!
Nice Video...a life saver....Thank you so much for this.
Glad it helped!
Top man. This is super-useful, and exactly what I needed for a project. Thanks!
Great to hear! thanks for watching and feedback.
Looks really helpfull, Thank you!
Glad it was helpful!
great tutorials! Thanks!
Glad you like them!
Great work! Thanks so much!!
You're very welcome!
Very helpful. Thanks for your work!
You're most welcome. Thanks for watching
Great content thanks for filling a gap for 64bit calendars.
thanks!
This is what I was looking for....! Super.
Glad I could help!
It's wonderful that you share this kind of information. Thanks
my pleasure, thanks for watching.
Thank you for the lesson, you, Sir, are so easy to follow makes this learning p;process fun....nicely done...
You are very welcome
Very instructive, thanks.
You are welcome!
This is perfect and very helpful! thank you
Glad it was helpful!
Super useful! Thank you!
Glad it was helpful!
GREAT. Thank you very much for that.
You are welcome!
Very nice .... just what I was looking for.
Glad I could help
looks very nice, thanks!
Thank you! Cheers!
Thanks again for this wonderful project. Really nice datepicker
You're welcome
Glad you like it!
Thank you for the video it helped a lot.
You're welcome!
I have a question. The file I received is CellDatePickerX. It works great in a worsheet, but can't get it to work in my form. Is this different than the PopDatePickerX?
Please see my response in email. There are 3 versions of DatePickers
@@VBAA2Z I received the version for userforms and it works perfect. I had a form already coded to import data from the selected row, etc. and the date picker worked with no problems. Thank you for this great tool. I can't wait to explore your other projects.
thank you, cheers!
Thank you for your helpful project
Glad it was helpful!
Estaba buscando justamente esto para completar mi proyecto, muchas gracias por compartir... :)
Thank you, it's very useful
Glad to hear that
Thanks you my dear your lessons are appreciated we hope you to show how we can search between two dates pls
You're welcome and thanks for your suggestion.
Thank you for sharing. I have been looking for solution for it !
Glad it helped
Hi There,
Even after considering ' Public Const DatePickerX_DateFormat = "d/m/yyyy" ' this line & hiding the other, date formating is not changing
it is possible cell is preformatted.
try printing it to cell in new workbook / sheet
@@VBAA2Z I am using it in a textbox not cell
@@ShivamTiwari-hw2bx please feel free to email me I can take a look
Exactly what I need for my project. Thx.
Glad I could help!
This looks to me exactly what we are needing.
Sure
I submitted download request from website, however there no download link available.
please be sure to check spam folder too.
How can I use this calendar in a cell instead of a userfom?
check here.
ua-cam.com/video/TsnRWqX1Q4s/v-deo.html
very useful tool, great job. thanks a lot for let us have this amazing code
You are welcome!
Extremely useful, thank you for sharing.
You're very welcome!
I finally managed to make it work, however now I have a whole new problem. I’ve had to switch to a multipage form and now it will not populate the textbox with the date from the calendar.
Very helpful thank you
Glad it was helpful!
Thank you for another great video! I've been following your series for a while now, and there's one problem I cannot fix with user forms. Can you adjust the user form to change it's size and zoom, depending on the user's screen resolution? This is a real issue when you create a userform in high resolution, and send it someone who has a low resolution, the controls would not fit the screen. Do you have any video on this topic by any chance?
Try manipulating Zoom, Width and Height Poperties.
thanks!! very helpful
Glad it helped!
Great and want to try this code. What is the number to download this demo code on the website?
In the description.
Awesome work.
Thank you so much 😀
can i have the copy on 028 ID
i requested it a few days ago but no response.
Please be sure to check spam folder too.
Awesome tutorial, congrats for the work
i intend to use it in a graduation project in witch i'm creating an KPI pannel, how may i quote your work in it?
Thank you! Cheers!
Thanks for creating this, I just have a doubt, this will work on tesxtbox associated with a userofrm, what if I want it to work on textbox not associated with a useform(i.e. textbox is placed on a worksheet), what code do I need to modify ?
You're welcome.
to write back to textbox in Sheet you can update below code / function to refer to control in Sheet and not in userform
ctrlName_SetDate = "dt_start": FormName_SetDate = Me.Name: PopDatePickerX.Show
Sub setDate()
@@VBAA2Z Sorry, didn't get you, Do I have to change code in Sub setDate() ?
yes.
here you'll find code set date value in Userform.
@@VBAA2Z I tried various codes, can't able to solve it :(
Can you help me?
sure - will take a look and get back.
This is awesome!
thanks!
How do I access this code to try it out? I saw the link with the ID's, but not sure which ID it was and how to download it.
Check out Free Projects / Source Code section for date pickers
@@VBAA2Z It only takes me to a WinZip installation page
@@VBAA2Z - I still cannot access your project code 027. It just takes me to a screen to install WinZip.
I never received an e-mail after signing up. Can you assist with this? Not in a spam folder. It is empty.
I think you'll getting some Ad prompt. Please click on Close [X] to continue to download form. Or email me at vbaa2z.team@gmail.com
Thanks for sharing your work
Thanks for watching!
Please how can I download the tool I clicked on the link and also searched the tool and also clicked on download a google form appeared and I wrote on the mail and the project ID *028* but i didn't receive anything
please submit request again. email respond might be delayed.
Wow this is really awesome, I hope this project can be applicable to Microsoft Access Forms too. Would be really useful as stock date picker in access is really difficult to use and not very intuitive compared to this. Very excited to try it in Access projects. Thanks Sir.
Thanks Jahvana, this was design especially for excel because of date picker issue in 64-bit but code should work with access form objects too.
WOW I had a week working I made a data picker for my form but for some reason the tool offered by excel was not working for me, this could help me😁
thanks. hope it helps
I write the email address, but no reply email for download this project.
please be sure to check spam folder too. all request have been processed.
This i genius!! what a champ!
Thanks Michael.
Please do not forget to subscribe to support the channel and for future updates.
What is the project ID ?, while going through the download it required.
028 DatePickerX - DatePicker for Excel UserForm - Pop Up
wow excellent video
Many many thanks
great work man
Thank you! Cheers!
Nice and helpful, thanks 😊
Most welcome 😊
Hi i found the link to download but, the adds and other links are taking other places and i dont see the download after i fill out the form, any help is highly appriciated.
if ads pop up you can click on X to close the window. to proceed.
awesome tutorial! I was wondering how we can get the file for it. already answered the google form for it.. thanks teacher!
Glad it was helpful! thanks for watching.
please be sure to check spam folder too
Hi! Where can i find the sample file?
sure, please check video description for download link
Thank you ....this is super.
Welcome 😊
Very informative
Glad it was helpful!
Thanks for the video sir. Is amazing.
Most welcome. thanks for watching
thank you for another useful video
Glad it was helpful!
Could you do a video on general guidelines to make 32-bit VBA compatible with 64-bit Excel, please?
Hi Wessel, thanks for your suggestion.
I have simple blog post on this vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html
this is so helpfull. thanks
You're welcome!
Very helpful post!
thanks!