Userform in Excel Data Add Search Update its simple
HTML-код
- Опубликовано: 7 сен 2024
- Check Description VBA Code Available
Simple way to Learn Userform in Excel in Hindi
All VBA Code Step By Step
USERFORM CREATION
Userform1
CommandButton1 = Transfer Data
CommandButton2 = Reset Form
CommandButton3 = Quit
CommandButton4 = Search
CommandButton5 = Update
Textbox1 = ID
Textbox2=Name
Textbox3=Contact
Textbox4 = Search
VBA Code :
Private Sub CommandButton1_Click()
Dim x as Long
x= Sheet1.Range(“A”&Rows.Count).end(xlup).row+
sheet1.cells(x,1).value=textbox1.text
sheet1.cells(x,2).value=textbox2.text
sheet1.cells(x,3).value=textbox3.text
textbox1=””
textbox2=””
textbox3=””
MsgBox “Transfer Data Successfully”
End Sub
Private Sub CommandButton2_Click()
Unload Me
Userform1.Show
End Sub
Private Sub CommandButton3_Click()
Unload Me
End Sub
Private Sub CommandButton4_Click()
Dix x As Long
Dim y As Long
x=Sheet1.Range(“A” & Rows.Count).End(xlup).row
for y = 2 To x
if Sheet1.Cells(y, 1).Value=Textbox4.Text Then
Textbox1=Sheet1.Cells(y,1).Text
Textbox2=Sheet1.Cells(y,2).Text
Textbox3=Sheet1.Cells(y,3).Text
End if
Next y
End Sub
Private Sub CommandButton5_Click()
Dix x As Long
Dim y As Long
x=Sheet1.Range(“A” & Rows.Count).End(xlup).row
for y = 2 To x
if Sheet1.Cells(y, 1).Value=Textbox4.Text Then
Sheet1.Cells(y,1).Text =Textbox1
Sheet1.Cells(y,2).Text =Textbox2
Sheet1.Cells(y,3).Text =Textbox3
End if
Next y
MsgBox “Update Data Successfully”
End Sub
Create Macro for Show Form Button
UserForm1.Show
Please LiKE | SHARE | SUBSCRIBE
One of the best tutorial on excel VBA data entry sheet. I have never seen such a descriptive point by point VBA script writing.
Thank you sir 🙏
V good job
Wow.... Awesome... Yarrr... Aap bahot a6ese samjate ho
super video
Hi !
DEAR SIR "
Aap ny best lecture diya hei , meri aap sy aik request hei , k kindly is trah ki aik aur short video lecture bnayn, jis mein delete , add picture aur ager koi name list mein na ho, to msg aaye, k data not found.
Sirf 3 textboxes aur 3 command button use hon.
Thanks Sir !💞
Very helpful this video
Thank you for very good teaching lesson,
video bhot helpful hai
بہت بہت شکریہ آپ جیسا سچا یوٹیوبر بہت کم دیکھنے کو ملا ہے اللہ آپکو دونوں جہاں کی خوشی نصیب کریں آمین
Very nice video
Great sir
Good technical teaching
isse accha sikhane ka tarika maine kahi nahi dekha
masha allah
good job.u learn it.
thanks you very much
excellent step by step guide.. i was looking for just that. hope, I will be able to creat my own shet following it,
Thank u Sir ji . This is really good lesson for everyone.
JazakAllah sir
I have been following you sir because your class super..I need sql also..
Good
Thank you..!
Thank Q Sir
Bạn giỏi quá!
Perfect
Hello Sir Nice Video for VBA User Form
Great Sir Thank u so much so help ful
Very Helpful Daood Ji.
You taught us how to create various software like your School data base software was awesome.
Plz make a video on how to lock that software for a particular period like we se a software we download for trial period then we have to purchase it.
Somewhat like that
Jinaab agar app say Rabtaa karnaa hooo tuo Kia tarikaa hai
Kamran Khan from Pakistan
great video its working nice thanks
Thanks sir, it is very useful
thank you. very useful video..
Thanks for watching
@@daoodcomputers welcome
Nice video and very helpful video
Thanks sir
sir pl upload the video of search command in excel sheet with the help of search form with date range eg from to
Thanks Sir Ji...
Wow thanks....sir
Nice video, really good job.
nice but sir thoda advance bnaye or is bar sath mein listbox mein bhi data show ho aisa byaye
welldone sir
Nice video sir, please show us how can we transfer data in multiple sheets with this user form.
Sir I m following your channel since long. I have learnt a lot. Thank U . I have one question .. i want to update data if condition met i.e. ID, If ID Exists data should be updated but if ID doesn't exist the data should be save in last row of database. Kindly help.
Nice job.
very good sir
Dear sir maine aapka channel new subscribe Kiya hai kyunki aapki video bahut badhiya hai. Please ek full tutorial video pivot table pr and vlookup and hlookup ki 1- 1 video banao Full bahut sare example ke saath
Sir can you please upload video of Photoshop in details
Good,VBA code for A4 size in excell sheet
let me know How to make form available on opening of the worksheet . I an new to VBA , but very clear explanation
Will upload soon
Can u plz make a video of daily,monthly etc. Loan collection system with auto calcuation...
Res,sir easy and simple coding good.
but coding ,delete previous and next button me send coding tutoriyal or put vba code, delete ,next,preview command button
Sir me be userform bi bna liya hai aur search and update button bi bna lye Hain aur ye work b karte Hain.
Aur ab aik slip button bnana hai k data search kr k slip button pe click karain aur data slip pe aa Jay aur us slip ko easily print Kiya ja skay.
Please is pe aik video bnayain..... please..
Can we create search option in same data base against contact number.
Suppose we have contact number which is in column c and by contact number we can get I'd and name is same form using search options.
Pls guide can we do like this?
Very nice video sir, I am working on a inventory project were i have text box for 'ID'. ID is of the format ST-AUG-0001, I wish to increment the month from AUG to SEP to NOV etc after each month and also increment sequence 0001 to 0002....very time i click on transfer button in user form. please explain with a video, this is very urgent for me. Thank you in advance.
Sir, i create e order as you show but i have a question if same date have two sales of same party then can the data sheet can show the data by addition?
As like Mr X purchase product A,B & C 10,20,50 qty respectively then Mr X purchase product A,B & C 20,20,70 qty on the same @t, How can i show data Date = 01/01/2020, Customer = Mr X, A=30,B=40,C=120
helpful sir can make a tutorial on how to print all records on which vlookup formula is applied but we want to print all record without entering lookup value again and agin using vba sir please we need your help
Sir plz ek vdo bana ye multi product purchase entry in table with user form
👍👍
I want to use MSComm control in excel vba to collect some data by useing serial port. But I can't. When I am going to use this then one dialog box come with massage " the subject is not trusted for the specified action." Now what I can do?
V.GOOD.SIR is mai 12 ya 13 box ka video bana aayn, please
Product ke name aur uski ret hsn ko kaise set karen VBA code me ki jaise hi koi product ka name likhen uski HSN MRP dono aa jaye. Thanks
Sir I have tried so many time to make update with this coding but it's not working
Can you advise for next
Thank you so much
SIR PLEASE MAKE INDIAPOST RD AGENT SOFTWARE YOU CAN EARN MORE
Userform me mouse scroll enable kayse kare ?..... Please make video on it.
Hello, can make custome id pass excel sheet consisting 100 sheets for 100 user id? I can engage professionally with you for this service
Hi I created this form its working fine , than I saved it, than I closed everything and open excel file again I can see my data but I cant see those buttons which we created, i can see only excel
Have you saved your file in micro enable format??
How to show slicer data in user form in combobox
SIR PLEASE MAKE INDIAPOST RD AGENT SOFTWARE
Sir, Good day. Sir, I we have Fruits Business, Importing. We want to make a stock list and sales with cost and Expenses and sale, after loss of profit
and we want to it for Each Consignment.., Can you help pls ?
How can the I'd number must be auto generated.mske a vdo
Private Sub CommandButton4_Click()
Dim x As Long
Dim y As Long
x = Sheet1.Range(“A” & Rows.Count).End(xlUp).Row
debug here plz check
User form1 me second sheet ya second user form kaise add krte hai
Sir mere worksheet me 3 sheets he muje sirf sheet2 save as karni he uska name sheet1 se 2 cells pahele fir date se ana chahiye... Ye user form me kaise kare... Apne espe video banai hogi to pls share kare...
Sir Workers Payroll बनाना बताईए
Aslam o alaikum,
Mjhe apki help chaiye. M aik aisa user form bnana chah rha hun jahan m apni different excel sheets ko link krun by category. Jaise hi category ka data put krun wo concerned sheet me chala jaye aur user form se search b kr skun.i hope you will help
Per sir Thoda problem aa raha hai mene Form me Command Button banaye the per Pahala wala command button to Form me Show ho raha hai baki ke button banane ke kuchh der bad Hide ho jaje hain Plz Solve my Problem
Agr ek hi Excel ki work sheet me bht sari sheet ho like 5 employee hyn 5 sheet hay or ek hi user form ho lakin ham jab data entry kryn tou wo jis employee ka ho automatically convert ho jay os sheet me... Plz esay claer lr Dyn I need .
That codeing is not sive places sir helps
VBA Coding aasan tarikhe se samjhana hai.. uske liye kya kare... Uske liye RS pay bhi karne ko tayyar hooo..
how can i show two Rows in two textbox
Form filling work me ek sath kaee form fill krne ka koi tareeka btaiye. Please help me in this topic
SIR AGAR EK JAISI DO ENTRY HO OR HUM SEARCH SE DONO ENTRY KO DEKHNA CHAHTE HO TO KYA KARNA PADEGA
Askm, jab ek sheet par data kisi workbook ya sheet se vlookup se laate h. Us value ko calculate karte h toh #value error aati h. kai criteria h Kisi mein value hoti h aur kisi mein nhi. kaise calculated value aaye
Sir, VBA code for Multi depend combobox VBA. i need
Sir ky mai issko ek alg software ki tarah use kr skta hu??
how to search data from multiple sheets in userform
I want to make daily collection of 1000 persons in VBA . Any idea
Watch Thisruclips.net/video/Lq3bGClwFc0/видео.html
buy from website
daoodcomputercenter.com/product/daily-collection-excel-template/
Discount Code
DCC-1103
How to prevent duplicate entry
Dawood bhai name se kese search karenge yeh abhi employee id se search ho raha hai name
sir school management se rile ted koi excel me software batayen
Sir ak asaa user form bnayn k students k subject wise marks add karnay hyn roll no.k according.
I mean mn mn drop down box say subject slect karo student ka roll no. slect karo aur us k marks main sheet mn automatically add hu jayn
does not work """run-time error 1004 method range of object _worksheet failed""""
मै जब search करता हु तो result 3 बार लिस्टबॉक्स मै display होता है.
और एक cell मै mahesh dabhade लेटर है.जब मै mahesh search करता हु तो ओ display होता है,लेकिन dabhade search करता हु तो display nahi होता.
Pls help
सर हमने userform बनाया और उसके बाद उसी शीट पर show userform का एक मैक्रो बनाया और वो सब सही से काम करे थे
परंतु जैसे ही हमने excel को बंद कर दोवारा शुरू किया तब न ही userform काम कर रहा न ही show userfom
इनके बाद मेने एक नई शीट पर फिर से userform बनाया और पूरी प्रक्रिया दोहराई परन्तु शीट बैंड करने के बाद दोवारा जब शीट खोलते है को काम नही करता
साथ ही save भी वैसे ही किया था जैसे आप न बताया था
User form Delete Ke Time Yes Or No kaise banaye
USERFORM SAY NAME SAY NEXT COLUMN MAIN PIC KASAY ENTER KARAY GAY COLUMN MAIN
Jaldi hi Video Aayega
@@daoodcomputers WAITING 😟
STILL WAITING
Sir abhe tak nhe ae video ap ka
Bhai jhoom karke banani chahiye
Fille bananako bad kece save Kari Konica formete sar
What is xlup sir.. please discribe
While writing code please keep zoom
VBA Code in Description
getting error Methos Range of object.Worksheet failed
VBA Code in Description
Kya mobile me user form bana sakte hai
Nahi
Sir,
File download karne ka link share Karo , please
Sir search nahi ho pa raha hai