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?
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🙏🙏🙏
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
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
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 🙏🙏🙏
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
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
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
![How To Add 3 Different Date Picker Calendars in Microsoft Excel [Free Download]](/img/n.gif)
Sir, Excellent and Superb.👌👌👌
Thank you
Excellent Sir
Sir I'm waiting ❤❤❤
very good😇
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?
Very good sir
Thank you 🙏
Welcome and thank you
Sir Aapke Video ko entazzar h
Thank you 🙏 already uploaded
Andriod me xlsm file run ho sakti hai.....?
Nahi
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
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🙏🙏🙏
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
Iske liye maine video banaya tha chat application but thoda wait kijiye jaldi ek aur multi user data entry upload hoga
Okay thanks
Sir, Very interesting method but Can I use this eny excel cell?
Yes this method can be used in any excel
Sir ek medicine store ke ek project banaye..
Keep watching will try to make
Sir if we type on number below 12 then it consider month. Please check
I checked and it worked. I would suggest please check the code again
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
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
Jo Maine function banaya hai uske last me hash dal de strong me
nahi samja sir
Sir , days ko 1 se 12 enter karne par ye month me convert ho raha hai.
Please solve it's sir
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
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 🙏🙏🙏
यदि कोई Student बीच मे फीस transport को छोड़ना चाहता है तो कैसे करे II ओर इसमें हम शुल्क माग पत्र भी कैसे दे
Sulk mang patra isi Saturday ko upload hoga rest agar bich me koi chhodna chahta hai to uske liye code me thoda change karnabhoga
धन्यवाद sir.. jo code change hoga wo bhi bata dena ..
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
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
@@vbAFun ji
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
Sir isko banane par variable not found massage arha code me
Aapne sayad variable ko mandatory Kiya hoga.
Top me option explicit likha hoga use delete kar dijiye ya fir variable declare kare
Variable defined Kaise kare
Days par code ruk ja raha hai
Code is not working sir..
I already check with multiple system and working fine check your system date format and change the according
Dasy value not found showing
@@vbAFun kindly help me sir
@@vbAFun in days error message is veriable not defined
It means in top of vba edit will be written option explicit either remove that or define the variable
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
You have written the wrong syntax on date serial function year no issue no correct
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