Date Picker pt2 | DatePicker in Userform in Excel | Customise Theme | Customise DatePicker

[@aaizu6473]

very nice video

[@vbAFun]

Welcome

[@KuldeepSingh-nq1vi]

Very nice and informative video Sir..

[@vbAFun]

Thank you ❤️

[@Biswas104]

Verry easy and help ful

[@vbAFun]

Thank you ❤️

[@abcd2-k4s]

Very nice 👍👍👍

[@vbAFun]

Thank you very much

[@asadreet7731]

very informative and base project to know about atmosphere of vba excel. thanks

[@excelshambhu]

Very Useful video

[@vbAFun]

Thank you jayesh

[@excelshambhu]

@@vbAFun Most welcome sir.

[@PiyushMedicalKnowledge]

Good video keep up

[@vbAFun]

Thank you Piyush

[@syedwasidali]

Super video

[@vbAFun]

Thank you very much

[@jewelmondal5626]

Awesome 👌

[@vbAFun]

Thank you very much Jewel Mondal

[@alyaharentertainmentcenter448]

Very Useful video ....

[@vbAFun]

Glad to hear that Al Yahar Entertainment Centre, Keep watching

[@Ayushtipsntrick]

Awesome.. thanks Ajay bhai Ajay bhai calendar button mein loop use nahi kar sakte kya ??

[@vbAFun]

Nahi button me loop use maine nahi kiya hai abi tak aur sayad hoga hi nahi

[@PiyushMedicalKnowledge]

@@vbAFun Have you used loop for textbox the same way you can use loop for buttons

[@PiyushMedicalKnowledge]

Loops can be used for buttons

[@PiyushMedicalKnowledge]

@@vbAFun I have already made a video on using loop for controls like Textbox Combobox You can watch them

[@vbAFun]

Yes dear I just created that module will share tomorrow thank you all for your suggestion

[@TheLaopi]

Very good, where download ?

[@vbAFun]

Watch part 3 of date picker where you can find link in description

[@noorwazir]

Supper Dupper

[@vbAFun]

Thank you very much. I appreciated

[@anamulhaque34]

Thansk . Your video is very helpful. But i faceting a problem I can't find listview tool in toolbar, and also in reference (Microsoft windows common control 6.0) Please describe about this I'm using ms Excel 2016

[@vbAFun]

Hi please check with excel version as in some excel version has no features of listview

[@anamulhaque34]

@@vbAFun which version do you use?

[@vbAFun]

@anamulhaque34 ibam using office 365 64bit

[@bulbulahmed3094]

hello .i m trying to use your date picker. everything is going perfectly . but when i try to use date in userform its not showing the value. please if possible give me the solution. thanks in advance. please be soon

[@vbAFun]

Hi can you download the file from part 3 where I made some change and upload the file

[@bulbulahmed3094]

@@vbAFun i tried but still not working. if you allow me want i can send my files.pls help me it will be very helpful for me.

[@vbAFun]

Hi thank you but right now I am busy in marriage function so I m unable to see this will continue after 25 th

[@bulbulahmed3094]

@@vbAFun no problem. Thanks a lot.

[@lalitpatil5375]

same problem is my problem please tell me also

[@hasmukhnirmal1263]

4 USERFORM HO TO SABHI USERFORM ME YE WORK KAREGA ?

[@vbAFun]

Yes

[@vbAFun]

Bus ek jagah code add karna hoga ek line ka

[@hasmukhnirmal1263]

@@vbAFun kaha per code add karna padega

[@vbAFun]

Mai kal iska update video upload kar raha hun use aap dekh lena aap aram se kar sakte ho. Multiple form ke sath sath multiple sheet me bhi bhi use kar sakte ho

[@ujkumar71]

on selection of button in date picker, month comes first in the text box. please suggest how to bring date in dd mm yyyy format

[@vbAFun]

Hi from part 4 download file and import in your userform after that goto code and change the day code

[@trader.fx1]

Hi . From which site can I download DatePicker and Microsoft MonthView Control 6.0 for Excel Office2016? Thanks

[@priyankarsamanta4020]

Sir VBA course sikhna chahata hoon. Apse.

[@vbAFun]

Thank you for your interest, we are going to start new batch from 1st march Fill this form for registration forms.gle/sZWUdLbq7wjTJFsG8

[@priyankarsamanta4020]

@@vbAFun Sir,apke sath contact karna hey. I have some personal question related to this course. Sir apki Official Whats app , mail address plz

[@safwankhan7779]

can we install common control 6.0 in window 7

[@vbAFun]

I think yes, please try to install

[@sallu21m]

sir ... how to enter the date in the format 01 Sep 2022 from the date picker ??

[@vbAFun]

Change the format dd mmm yyyy

[@sallu21m]

@@vbAFun where exaclty this format is to be changed ...can you specify pls ?

[@vbAFun]

Please watch the video and modify as per ur requirement

[@vishalwakade3844]

Nice sir but How do I use Date Picker in Excel reports? Please tell me

[@vbAFun]

Do you mean in excel sheet? Agar aap sheet me use karna chahte hai to simply jaha pe form. Activecontrol likha hai oha pe activecell likh de and cell selection mevent me jakar show kar de calander ko

[@PiyushMedicalKnowledge]

@@vbAFun That's okay but why not you make it in right click context menu It will be beneficial

[@vbAFun]

Thank you for your feedback. But I make video for learning with normal code to develop skill and logic to develop a simple application.

[@hasibgns]

I'm on Windows 11, can I install Microsoft Common controls?

[@vbAFun]

Yes why not

[@premchandpatel7605]

Made datepicker but can't use it pls tell me

[@nageshwarsoni6712]

सर आपके इस वर्क के लिए तो कितनी भी तारीफ करें कम है। लेकिन इसमें एक और लॉजिक डायनामिक हो जाता तो एप्प और भी जानदार हो जाता। कलर के लिए जिस शीट का उसे किये हैं उस शीट को डायनामिकली क्रिएट कर दें तो अच्छा रहेगा।

[@vbAFun]

Bahut aacha kal mai ek video upload karunga usme aap dynamic kaise banana hai sikh sakte hai.

[@MusicWorld_ZS]

Hello bro good morning sir koi aesa form bhi create kare jis say cable walo ki fees or customer add delete ka option bhi ho jis tarha ap nay school manager k liay form bnaya hai

[@MusicWorld_ZS]

jis mein monthly report add ho sakay es nay last month kitni fes di hai or baqi kitni hai

[@vbAFun]

Thank you for your suggestion. We will try to make as per your requerment

[@MusicWorld_ZS]

thanks you

[@vivekdesai7674]

Beautiful calendar. But I am facing one problem. I.e How to bring calendar on form when it gets loaded. In my case calendar opens but it goes back of user form where I want to insert date. Pl clarity

[@vbAFun]

Hi please see part 3 of this video and also download the addin given in description then import in your VBA editor and check

[@hasmukhnirmal1263]

TODAY DATE BUTTON ALAG COLOR KA HO

[@vbAFun]

Thank you for your feedback, we will update in next application

[@inderpalbaseer4635]

Sir ji I am not able to add this Callender to any other project please help

[@vbAFun]

Please download file from the description and use that

[@inderpalbaseer4635]

@@vbAFun sir ji I had downloaded and calendar form ko upload bhi Kiya but after clicking on date the values is not getting updated

[@arindamghosh1054]

Sir, Your coding is awesome, bt in date picker whenever i change the year, the dates are not updated accordingly unless I change the month name too.

[@vbAFun]

Hi yes there was a small bug in this file i have corrected and given the file link in datepicker updated video description

[@arindamghosh1054]

Got it sir..now working fine.but "ActiveControl' is not showing the date in textbox, I had to change it to : textbox1.value ="

[@vbAFun]

I have revised the code with function from active control

[@user-th3hf9lr2l]

How to make Ad to BS date picker . it need to me

[@vbAFun]

Bhai mujhe ye batayiye ad to bs hota kya hai tabhi to mai uspe kam kar sakunga

[@user-th3hf9lr2l]

@@vbAFun English date ko Nepali(Nepal)date me convert karke kaise Nepali Datepicker kaise banasakte hai.

[@vbAFun]

Code me jake formate ko change karna hoga

[@user-th3hf9lr2l]

Kaunsa code ko change kare koi hints batayenge to bohot meherbani hogi

[@user-th3hf9lr2l]

Nepali calender me nepali datepicker kaise banasakte hain.isise related video banaiyena sir bahut se logoke liye advantage hoga

[@arindamghosh1054]

Sir, how to restrict a text box to accept previous date?

[@vbAFun]

You can use change event for this or you have to create a customised datepicker

[@arindamghosh1054]

@@vbAFun thank you sir

[@Priyam5]

Sir Date picker, Multi page par ,not Working .... please solve Get a lot of benefits from your videos.

[@vbAFun]

Please check description of part 3 video and use that have made some change in code

[@lalitpatil5375]

form.ActiveControl = Dateserial(..... Ye line execute nahi ho rahi hai .... please tell me solution

[@vbAFun]

Please don't use this code, I would suggest please download bas file from datepicker updated and import in your vba editor

[@lalitpatil5375]

@@vbAFun Sir, bas file kahase download karna please batayenge.

[@vbAFun]

Datepicker updated part 3 ke description me check kare

[@lalitpatil5375]

@@vbAFun Thank You very much Sir problem solve ho gaya . and also thanks for good knowledge of programing Thanks again and good night ..

[@ramdasthorat3165]

Sir ji ese uninstall kaise kare kyonki install karate samay bich me fas gaya hai Please bataye

[@starcitycomputer7457]

सर जी हम आपको मेल कर सकते हैं हमारे द्वारा बनाया गया जीएसटी बिलिंग सॉफ्टवेयर कैलेंडर date show Nahin ho rahi hai

[@vbAFun]

Okay

[@suvodas7269]

I am trying to use your datepicker, everything is going perfect but, when i try to use in userform, its not showinh the value. If possible please give me the solution as soon as possible. I need this urgently

[@vbAFun]

Hi I have changes in the code and file is given in datepicker part 3 datepicker updated video description please download and follow the instructions given in text file

[@lalitpatil5375]

Hi Sir, I m trying to use your date picker. everything is going perfectly . but when i try to use date in userform its not showing the value in textbox field

[@bulbulahmed3094]

Don't keep your textbox under any lebel. Just place your textbox to direct userform. hope your problem will be solved.

[@AbdulSattar-ox8jt]

Sir Same problem I am facing. many shuro sy aap ky steps ko buht bareki sy follow kiya hy @@bulbulahmed3094

[@KabulXPlus]

good evening sir toolbox main dtpicker nahi hain i try very much to find it and install it but i cant. can you help me ?

[@vbAFun]

Hi thank you for watching the video, like and share. Basically datepicker work in 32 bit excel. You can use customized date picker which I uploaded

[@2Nmidea]

I did all the coding correctly but selecting the date does not show the date in the text box

[@vbAFun]

I am sorry but could you let me know the exact error or show me error snapshot on instagram

[@kishpatil3317]

@@vbAFun same problem here , i also did correct coding bt after selection of date, it's not shows in txt box of user form. No any specific error is showing. I think, it's active control issue. Plz help sir

[@vbAFun]

Hi please download file from updated datepicker video description

[@shaileshroy8974]

Sir mere user form me kam nahi kar raha solution please

[@vbAFun]

Please check part 3 and download file given in description

[@mohdshahbazkhan878]

Hi Sir I want to use this calender in two form but what error comming first form is working well but when I try to use another Form Every think is ok but after click calender button date not insert in textbox what is the resion pls help me sir UserForm1.ActiveControl = DateSerial(Me.yBox, Me.mBox.ListIndex + 1, Me.Btn10.Caption) this form working UserForm2.ActiveControl = DateSerial(Me.yBox, Me.mBox.ListIndex + 1, Me.Btn10.Caption)but one not working Unload Me

[@vbAFun]

You can download file given in part three video or watch and use the process as in text file

[@mohdshahbazkhan878]

Part3 also I checked but Same error Comming Object doesn't support this property or method Pls Help me sir @@vbAFun

[@mohdshahbazkhan878]

I keep this textbox inside the frame that's why not working now working thanks sir

[@starcitycomputer7457]

User form Text box not show Date

[@starcitycomputer7457]

आपके द्वारा कैलेंडर कोडिंग बहुत है परंतु दूसरे यूजरफॉर्म में डेट शो नहीं हो रही है

[@vbAFun]

Maine ek file download ke liye de rakha hai ise download karke apne userform me import kar lijiye fir usko use kijiye

[@starcitycomputer7457]

@@vbAFun sir file ko download kha se kar na hi

[@vbAFun]

Description me link diya hua hai

[@starcitycomputer7457]

Thanks

[@neerajshrsth]

don't work in multiiuser form

[@vbAFun]

Yes there was some bug I have fixed that and final code link given in updated datepicker

[@muhammadasifkhan3495]

Solve run-time error '400':

[@vbAFun]

Please watch drill down data entry for this error resolution

[@mohammadmohsin3922]

Bht palti marte ho yr poora form banwane k bad bolte ho ek kam karen ye karlen tum to kar sakte ho sb kch lekin tumare students abi students hen wo full trained nai hain poore project ghor se dekh k video pe aya karo bich bich me mehnat zaya karwa dete ho pehly ye karo pehly wo karo

[@vbAFun]

Hi so sorry but problem ye hai hai ki mai bhi project live hi banata hun. Jiske karan kusch galati mere se bhi hota hai.

[@kaleem77]

Awesome 👌 pro sir

[@vbAFun]

Thank you and keep watching