Sir ek query hai , Agar ham user form se data entry kar rahen hain , (mobile number unique data hai) agar wo data pahale se available hai to pahle wala remove ho jaye new entry se replace ho jaye
I'm use this code my project but login form is first show and then second form is continuing work on this form. Plz tell me what exact code. Only active or Deactive in code use this userform show
Sir, apne Notepad use karke Excel ko hide karna sikhayete ek video me. Woh wala trick or is trick me Keya difference hai? I mean isme kuch extra facility milta hai Keya ?
Assalamu alykum, thanks to show something new. But user form (sheet1) is OK. But how we maintain Database Sheet for the same workbook? suppose..."Form make in Sheet1" and "Data base in Sheet2" means how we maintain Data sheet due to all are hide and we can't see sheet2 .... could you please review again?
See if you want to keep database in sheet 2 and form will be display in sheet one then you can write a code for show the data ase then form will hide and show the data ase i. Sheet 2 when you select sheet 1 or click on the show form your database will hide
Sir Jab ham USERFORM wali excel file open karke dusri excel file open karte hai bad me vapis USERFORM wali file me aate hai to file PE click karne bad bhi formulabar & sheetTab hide nahi ho rahi...
sir, waise toh Splash screen me processing dikhana chahiye Jaise {splashscreen text = Loading dashboard...} VBA= Load MyDashboardform1 {splashscreen text= Loading customerdb...} Load MyDashboardform2 {splashscreen text= Loading InvoiceForm..} Load MyDashboardform3 Aisa Real Splash screen ho jaise Excel ka Uska baad, 5 seconds baad... VBA =Unload me Show DashboardUserForm1 After User hits Exit on form or on excel BeforeUnload= VBA= Call UnloadAllUFFunction()
Yes aisa hota hai but us tarah ke liye bada project hona chahiye sath me jab excel bagairah khulta hai to Aisa dikhta usme hota kya hai bahut sare file ko open karta hai background me aur store karta hai isliye o dikhata hai but excel me itna bada project banta nahi hai
@@vbAFun excel word PowerPoint all files are zip files believe or not if you ren(dos command) and chng extn to .zip then you can see xml file also . If you save word as web page, sometime xml is created.
Sir is me ak ishu aya he Ishu he is ke farmula bar me jab ap ne last me dusri file open krke dobara bnd ki or software wale me ayi to farmula bar phir open hogya
hello sir Namaste, sir software khulto raha he magar dusre excel file open kiya to nahi khula yeh message aya- "excel can't do this because dialog box is open please close first to continue" yeh kiu keheta he help me solution bataye
Kaisa laga ye tutorial jarur bataye
How you like this Please comment
Ek dam Jhakaas
Sir ek query hai , Agar ham user form se data entry kar rahen hain , (mobile number unique data hai) agar wo data pahale se available hai to pahle wala remove ho jaye new entry se replace ho jaye
@chandrashekharprajapati9451 save update ke liye already bata rakha hai please follow
Sir thank you so much. I'm facing the same problem in my office. Lots of thanks ❤❤❤❤
Welcome keep watching and sharing
Bahute badi problem solve ho gya sir...
Thanks a lot for the valuable information
Really Excellent trick. Thanks a lot for sharing it with us.
Welcome and thank you for your comments
Nice job, May you kindly show me the video that teaches how to share a macro-Enabled VBA Work book with multiusers?
Great as always.
Mera ek yahi sawal hai k kya hum ise agar Share folder me rakhe to ye Multiuser k jaisaa kaam karega? Agar Sare PC LAN me hai to?
Yes ho sakta hai but database access ya SQL me hona chahiye
Sir aap jo Note pad wala method sikhye wo v bohat accha kam kara h
Yes, o bhi kam karega,
Sir ek baar VBA ka Basic to advance ka class start kijiye please.
Good evening sir 🙏 Thank you Sir for the intresting new wonderful VBA code.
please let us know the code to merged excel sheet also doesn't seen.
I mean you want to merge cell or file
@@vbAFun when we open another new Excel file, user form's Excel file doesn't appear sir.
Sir
Yearwise kaise maintain karenge
Like total management for year 2023-24, 2024-25, likewise
Please make a video on it
If possible kindly make video for maximize application form
Sir login userform me bhi aisa problem hota hai dusre excel file khulle par
Iska bhi solution pataiyega
Sir can we resize the application window size same as userform ?
Yes but that is complicated
I'm use this code my project but login form is first show and then second form is continuing work on this form. Plz tell me what exact code. Only active or Deactive in code use this userform show
Ajay Sir....
instead of "Ribbon" Hide Code we can use simple as
Application.DisplayFullScreen = True
Can You guide us.
Hi, after using this code, press esc key and check what is the impact 😊
@Ajay Sir, Thank You very much to clear doubt❤
Sir, apne Notepad use karke Excel ko hide karna sikhayete ek video me. Woh wala trick or is trick me Keya difference hai? I mean isme kuch extra facility milta hai Keya ?
Haan, usme kusch bug the
From Bangladesh
class willbe attend
Thank you but you don't need to join class you can learn from here free if you have any doubt then you just join this channel
Sir; Please go for Ms. Access ... so we awaiting for a long time ...
Thank you please next video on that from starting
VBA me agar quit command use kiya to baddme open hone per us vba ko edit kaise kare??
Very useful trick 🎉❤
Thank you
Hello sir isska yeh zoom wala bhi dekhna band ho sakta hai kya?
Yes but uske liye thoda aur modifications ki jarurat hogi
Sir woh bhi zarur bataye aur ek video aisi banaye jismein hum login form mein number dale aur otp mobile par aaye usse login ho please sir
Assalamu alykum, thanks to show something new. But user form (sheet1) is OK. But how we maintain Database Sheet for the same workbook? suppose..."Form make in Sheet1" and "Data base in Sheet2" means how we maintain Data sheet due to all are hide and we can't see sheet2 .... could you please review again?
See if you want to keep database in sheet 2 and form will be display in sheet one then you can write a code for show the data ase then form will hide and show the data ase i. Sheet 2 when you select sheet 1 or click on the show form your database will hide
@@vbAFun thanks for yr valuable time.
Sir make student management in ms access tutorial
Yes very soon will start
Sir
Jab ham USERFORM wali excel file open karke dusri excel file open karte hai bad me vapis USERFORM wali file me aate hai to file PE click karne bad bhi formulabar & sheetTab hide nahi ho rahi...
Is there a video of how you created the user form?
There is lots of video for creating userform on channel
sir,
waise toh Splash screen me processing dikhana chahiye
Jaise
{splashscreen text = Loading dashboard...}
VBA= Load MyDashboardform1
{splashscreen text= Loading customerdb...}
Load MyDashboardform2
{splashscreen text= Loading InvoiceForm..}
Load MyDashboardform3
Aisa Real Splash screen ho jaise Excel ka
Uska baad, 5 seconds baad...
VBA =Unload me
Show DashboardUserForm1
After User hits Exit on form or on excel BeforeUnload= VBA=
Call UnloadAllUFFunction()
Yes aisa hota hai but us tarah ke liye bada project hona chahiye sath me jab excel bagairah khulta hai to Aisa dikhta usme hota kya hai bahut sare file ko open karta hai background me aur store karta hai isliye o dikhata hai but excel me itna bada project banta nahi hai
@@vbAFun excel word PowerPoint all files are zip files believe or not if you ren(dos command) and chng extn to .zip then you can see xml file also . If you save word as web page, sometime xml is created.
Sir Financial Statements preparing videos 🙏🙏🙏🙏
Good will upload
@@vbAFun HOW TO FIND SUM LOOK UP VALUE IF MORE THAN 02 AMOUNT IN TABLE ARRAY (LOOK UP VALUE, A, A RS.50000, A RS.60000, A40000 , TOTAL RS.150,000
Sir es s pahle wala jo application bata rahe the uska
Next video sir
Jisme last
Password change
Randbetween s kiye the
O to maine video already upload kar rakha hai ki kaise aap password kaise change kar sakte hai
Thanks sir
Welcome
Nice
Vai a. Software chai a weightbridge ka camera wala
Can you connect me on instagram for professional work requirement
I want this software always on top of all windows
I think it maybe not possible?
👍 sir🙏
Thank you
Sir is me ak ishu aya he
Ishu he is ke farmula bar me jab ap ne last me dusri file open krke dobara bnd ki or software wale me ayi to farmula bar phir open hogya
Yes but ek bar aap sheet pe click karenge to hat jayega
🎉🎉🎉
hello sir Namaste, sir software khulto raha he magar dusre excel file open kiya to nahi khula yeh message aya- "excel can't do this because dialog box is open please close first to continue" yeh kiu keheta he help me solution bataye
Iske liye maine bataya tha ki form ka model change karna hoga uske bare me video me bata rakha hai
Create bank passbook print software
কিভাবে ডাউনলোড করবো
Ye bahut hi simple hai just watch and create
Hellow sir
Sir is file ki download link mil sakti hai?
Hi this is paid application
sir comple excel ka look background me remove nhi hue ga kya
Ho to jayega but ohi problem hoga Jo hamne video me bataya
Very good
Thanks