Why Spending Time to Create DATEPICKER in Excel User form

Don't Use: Why Spending Time to Create DATEPICKER in Excel User form
Hi friends, now you don't need to use Date-picker in Excel or User form for selecting date. Now you can use User form like excel worksheet where you can put the date and control automatically convert the date format. It will help you to fast your work.
Our Aim to Develop Skill in Excel :
=============================
Excel Userform Development
Excel Vba Projects
Advance Excel vba
Advance Excel Userform
Advance Microsoft Excel
Excel Software Development
Excel vba UDF (User defined function)
How to Earn Money from Excel Work
=============================
About Vba Fun
=================================
एक्सेल वीबीए यूज़रफ़ॉर्म डिज़ाइन: डाटा एंट्री और सॉफ़्टवेयर विकास को आसान बनाएँ। हमारे विस्तृत ट्यूटोरियल में एक्सेल में विज़ुअल बेसिक फ़ॉर एप्लीकेशंस (वीबीए) के ज़रिए सॉफ़्टवेयर विकास का अध्ययन करें। यहाँ आपको यूज़रफ़ॉर्म डिज़ाइन करने के तरीके, डेटा एंट्री के लिए वीबीए कोड, और कॉम्बोबॉक्स और लिस्टबॉक्स का उपयोग सीखने के लिए सरल विधियाँ मिलेंगी। आप डेटा प्रबंधन को उन्नत और प्रभावी बनाने के लिए वीबीए कोड के नमूने भी सीखेंगे। तो अब नहीं, अक्सर दुहराए जाने वाले कार्यों से मुक्त होकर एक्सेल मैक्रोस के जादू को अपनाएँ और उत्पादकता का अनुभव करें। शुरू करें और डेटा के साथ काम करने के नए तरीके खोजें!
Learn how to create simple and interactive forms in Excel with UserForm design. Develop your own software right within Excel, making tasks easier and more efficient. Add VBA code to automate data entry, eliminating repetitive work and saving time. You'll be amazed at how easy it is to use ComboBox and ListBox controls in your UserForms to create drop-down menus and select items effortlessly.
In our beginner-friendly Excel VBA tutorial, we'll guide you step-by-step through macros, Excel programming, and VBA essentials. Get hands-on experience with practical examples, and master the art of VBA programming for Excel. Whether you're a novice or an aspiring Excel guru, this tutorial has got you covered.
With our Excel VBA project, you'll gain a solid foundation in VBA programming and take your Excel skills to the next level. Explore the world of Listbox and Listview controls to manage data and create dynamic user interfaces. Embrace the power of Excel macros and revolutionize the way you work with data in Excel. Start your VBA journey now and unlock endless possibilities for streamlining your Excel tasks!
=================================
Join this channel to get access to perks:
===============================
/ @vbafun
===============================
Never Seen Before Playlist in Excel Vba :
==================================
• Never Seen Before Tricks
==================================
Other excel vba training Video :
==================================
School Manager - Student Admission, Student Receipt, School Software
• School Manager Pt 1 | ...
Small Business Applications - sale/purchase/inventory
• Small Business Applica...
Employee Manager
• Employee Manager
School manager in excel
• School Manager
DatePicker in excel
• DatePicker
Advance Data Entry Software in excel
• Advance Data Entry App...
PoS in Excel with Image Control
• PoS with Image Control
PoS in Excel
• PoS ( Point of Sale) i...
===================================
Our Social Media Contact :
===================================
Facebook : www.facebook.c...
Instagram : / vbafun.ajay
Facebook Group : / 264521978273573
Facebook Page : / excelapplicationvbafun
Twitter : / ajaypreetam
====================================
#ExcelApplication #excelvba #userform #MSAccess #MsExcel

[@intakhabkhan9649]

Sir, Excellent and Superb.👌👌👌

[@vbAFun]

Thank you

[@monirajv]

Excellent Sir

[@ISLAMIC10164]

Very good sir

[@vbAFun]

Thank you 🙏

[@vbAFun]

Welcome and thank you

[@VikasAggarwal-ht8gw]

very good😇

[@muhammadhanifsoomro3166]

Sir I'm waiting ❤❤❤

[@pareek_akhi]

Sir Aapke Video ko entazzar h

[@vbAFun]

Thank you 🙏 already uploaded

[@KukieSingh-mi7sb]

Hi, Thanks for valuable Info. I have a question to ask as following, Hope you will guide better to stop being corrupted file like... Excel VBA Project have created a new set of worksheets and renamed all the original worksheets in the VBA screen, e.g. Sheet10 becomes Sheet101, Sheet13 becomes Sheet131. This causes the UDF to stop functioning. The "new" "sheet10" and "sheet13" do not seem to exist anywhere but in the VBA project window. 1) What causes this? 2) How can I fix it? 3) How can it be prevented?

[@lalitpatil5375]

Sir, Please give me a link for above video calender shows fill textbox with select date on video time 1:48 , how to display, i am not understand

[@adeshraka6668]

Andriod me xlsm file run ho sakti hai.....?

[@vbAFun]

Nahi

[@khadimhussainmomin1315]

Sir its very useful thanks. Sir bohat mahine se ek request hai ki ek ms access pe puri multiuser app banaye. kyu ki excel me multiuser app kaam nahi karti. So please

[@vbAFun]

Iske liye maine video banaya tha chat application but thoda wait kijiye jaldi ek aur multi user data entry upload hoga

[@khadimhussainmomin1315]

Okay thanks

[@souravgupta9775]

Sir, Very interesting method but Can I use this eny excel cell?

[@vbAFun]

Yes this method can be used in any excel

[@muhammadhanifsoomro3166]

Sir aik aur humble request Ka Running balance Debit credit Ka second video search and update ho wo zaroor dalen kiyo Ka search update smart coding method sy Nahi ho Raha🙏🙏🙏

[@tapanraul6041]

Sir ek medicine store ke ek project banaye..

[@vbAFun]

Keep watching will try to make

[@snehcrebaroda82]

Sir if we type on number below 12 then it consider month. Please check

[@vbAFun]

I checked and it worked. I would suggest please check the code again

[@khadimhussainmomin1315]

Sir date me hame date aur month k baad HASH - Likhna padta hai to voh automatic date aur month k baad aa jaye to data entry krne me speed aati hai to please ye bataye

[@vbAFun]

Jo Maine function banaya hai uske last me hash dal de strong me

[@khadimhussainmomin1315]

nahi samja sir

[@amitgoswami9629]

Sir aap se request hai ki Userform mein Pdf file load kar ke ush file kishi bhi mail se send and Delete and search yei sab kese banayege

[@muhammadhanifsoomro3166]

Sir ya trick boht hi bariya ha lakin sir aik code aisa ho Ka hum 2205 type Karen aur automatically 22/05/2024 Yani kah year automatically aajayen aur hamen( - ya /) type karny ki zarorat na pary 🙏🙏🙏

[@Rajesh661]

sir same TO same code dala par date agar 12 se kam dalate he TO isame date change TO jati he date ki jagah month badal jata he Jaise isame 2-6- 2024 dal raha hu TO 6 Feb 2024 Show kar raha he

[@vbAFun]

main bhi check kiya but mere system aisa koi issue nahi aa raha hai, aap ek bar system ke date ka format dekhiye, region ke setting me

[@Rajesh661]

@@vbAFun ji

[@Rajesh661]

Sistam me sab sahi he sir Coding me jaha ctrl=dateserial dal rahe he vaha date change ho rahi he day ki jagah month badal raha he

[@jitendrakumar-fy4hh]

Sir , days ko 1 se 12 enter karne par ye month me convert ho raha hai. Please solve it's sir

[@vbAFun]

Hi thank you for your comments but as you see in the video of the number count is less than 2 then it will not go in month

[@raghunathsah5241]

Sir isko banane par variable not found massage arha code me

[@vbAFun]

Aapne sayad variable ko mandatory Kiya hoga. Top me option explicit likha hoga use delete kar dijiye ya fir variable declare kare

[@raghunathsah5241]

Variable defined Kaise kare

[@raghunathsah5241]

Days par code ruk ja raha hai

[@pareek_akhi]

यदि कोई Student बीच मे फीस transport को छोड़ना चाहता है तो कैसे करे II ओर इसमें हम शुल्क माग पत्र भी कैसे दे

[@vbAFun]

Sulk mang patra isi Saturday ko upload hoga rest agar bich me koi chhodna chahta hai to uske liye code me thoda change karnabhoga

[@pareek_akhi]

धन्यवाद sir.. jo code change hoga wo bhi bata dena ..

[@devilofmyworld18]

Code is not working sir..

[@vbAFun]

I already check with multiple system and working fine check your system date format and change the according

[@devilofmyworld18]

Dasy value not found showing

[@devilofmyworld18]

@@vbAFun kindly help me sir

[@devilofmyworld18]

@@vbAFun in days error message is veriable not defined

[@vbAFun]

It means in top of vba edit will be written option explicit either remove that or define the variable

[@purshottamsharma5039]

when i write date no less than 13 it reads as month like i write 2 then it shows 6 feb 2000 it is no wrking properly please provide solution Sub convertDate(ctrl As MSForms.TextBox) If ctrl = "" Then Exit Sub If InStr(ctrl, ".") > 0 Then MsgBox ("you can not use Dot,kindlu use - or / only"): ctrl = "": Exit Sub If Len(ctrl) < 3 And IsNumeric(ctrl) Then Days = ctrl MonthNo = Month(Date) Yearno = Year(Date) ctrl = DateSerial(Yeaeno, MonthNo, Days) End If If IsDate(ctrl) Then ctrl = Format(CDate(ctrl), "dd,mmm,yyyy") Else GoTo endline: End If Exit Sub endline: MsgBox ("please enter correct date") ctrl = "" End Sub

[@vbAFun]

You have written the wrong syntax on date serial function year no issue no correct

[@AHKhan-up1fc]

Dear Sir Please change in Module "dd,mm,yyyy" then Change in User Form in Command Button Code Sheet1.Range("A1")=textbox1.text not value and then go to sheet1 and go to Format cell And Click on Text not date so your problem my be solved