Create Userform in Excel VBA Macro in Detail

No video

Create Userform in Excel VBA Macro in Detail

Рет қаралды 160,108

Күн бұрын

Create Userform in Excel VBA Macro in Detail. Learn step by step.
Udemy course details:
1. MS Office Training: www.udemy.com/...
2. Excel VBA Training: www.udemy.com/...
3. Excel Training in Hindi: www.udemy.com/...
4. Excel Training in English: www.udemy.com/...
Courses in DVD:
1. Complete Excel (Excel + VBA - Macro) : www.amazon.in/...
2. Excel VBA - Macro Training: www.amazon.in/...
3. Excel Training in Hindi: www.amazon.in/...
4. Excel Training in English: www.amazon.in/...
Subbscribe to our youtube channel for latest update.
For Classroom training at Noida: www.iturninstitute.com
For our Blog: www.learnmiseas...

Пікірлер: 139

@bokingo.chubkreino815 2 ай бұрын

this is amazing!! so concise, straightforward and complete for a person learning the Excel VBA Macro for the first time! keep up the good work!

@annatjienankela4594 2 ай бұрын

For those that got the 1004 error: there should be 1 entry in the first row below your headers. In all the columns you're planning to populate.

@saffetaltun833 6 ай бұрын

Thank you Mr. Training by Himanshu I wrote it based on the questions in the comments. In order to record data; Headings should be entered in the first line, and records should be entered as if data were made in the second line. (Range("a1").End(xlDown).Offset(1, 0).Value = Range("a1").End(xlDown).Value + 1) ←this snippet persists the sequence number.

@trainingbyhimanshu 6 ай бұрын

You may try this Range("a1048576").End(xlup).offset(1,0).value.. with this method a single entry is not needed.

@karthikeyanalagu2180 2 ай бұрын

Thats Awesome. I have created an userform with this video for my daily business. My sincere gratitude to you

@trainingbyhimanshu Ай бұрын

Thanks

@PortalGroup-h1v 29 күн бұрын

Thank you for for a lesson Mr.

@Grem305 3 жыл бұрын

Thank you very much. I do appreciate your patience and clear explanation. Keep up the good work

@trainingbyhimanshu 3 жыл бұрын

Thank you

@hadbarahhali6586 2 жыл бұрын

thank God you exist

@naiks5638 4 ай бұрын

Sir, thank u very much for ur easily graspable way of teaching strategy.. much appreciated...

@don8919-t2n 2 жыл бұрын

Thank you for the lesson, you, Sir, are so easy to follow makes this learning p;process fun....nicely done...

@naveenkumardks678 4 жыл бұрын

Hi Himanshu, it's a really simple and better way of starting the Userforms thanks for sharing your knowledge

@BASITKHAN-hs3ij 2 жыл бұрын

Thanks alot sir i have created customer userform with help of your video 👍 for my project❤

@luciferiq1428 10 ай бұрын

Thank you for the lesson

@rimpyrajpoot7842 4 жыл бұрын

you r the best programer sir bahut acha samjhate hai or bhi thora isko acha banaye please ek fectory ka form kaise banaye please bataiye

@rsrinivasan5591 Жыл бұрын

Thanks for your tutorial very understand me and easy

@agoezcoopral 4 жыл бұрын

You're the best... I follow all your steps.. it's work..

@BharathGowda-n4l 5 күн бұрын

Thank You

@umeshsrivastava9034 2 жыл бұрын

Thank you ! I have made this form for my institute project.

@tejasdhaware1909 2 жыл бұрын

Thank you sir it is working , is Very usefull for me but Fist Entry is a manual type so this fact is telling Other Student

@vsverma1989 2 жыл бұрын

Really helpful. Thanks Himanshu!

@lalitthapa4315 2 жыл бұрын

Thanks buddy for creating this tutorial !!

@maicabookkeepingservices332 2 жыл бұрын

Thank you very much. This Video helps me a lot.

@robbysandhu4425 3 жыл бұрын

Unique explanation 👌 I have understood everystood you go by..Thanks

@trainingbyhimanshu 3 жыл бұрын

Thank you

@venkataravikiran 4 жыл бұрын

this is a great beginner tutorial for creating forms

@e.5990 Жыл бұрын

Great tutorial. Thanks!

@raosatyapalrao8749 Жыл бұрын

Very Useful, Thank you

@vinnysurfo 7 ай бұрын

Thank you so much. I was trying to find a way to do this on TypeScript but it would not show drop-downs.

@tapan4253 6 ай бұрын

how to give the condition in save button like " do you want to save the data?" and in my excel unload me is not working, when i put this command then whole panel will close.

@koyenadutta5747 Жыл бұрын

Sheet1.Activate Range("a1").End(x1Down).Offset(1, 0).Value = Range("a1").End(x1Down).Value + 1 Range("b1").End(x1Down).Offset(1, 0).Value = TextBox1.Value Range("c1").End(x1Down).Offset(1, 0).Value = TextBox2.Value Range("d1").End(x1Down).Offset(1, 0).Value = ComboBox1.Value If CheckBox1.Value = True Then Range("e1").End(x1Down).Offset(1, 0).Value = "Yes" Else Range("e1").End(x1Down).Offset(1, 0).Value = "No" End If Unload Me This code is not working dont know why

@trainingbyhimanshu Жыл бұрын

There should be atleast 1 entry in that data. I mean below the Headings do one entry manually then only it will work.

@jeaniefamilywong 10 ай бұрын

@@trainingbyhimanshu I entered 1 row entry. Still it did not work. The debug informs me of this error message "Range("a1").End(x1Down).Offset(1, 0).Value = Range("a1").End(x1Down).Value + 1" Application-defined or Object-defined error.

@amitshinghaniya616 2 жыл бұрын

It's very nice and easy also thank you sir 😊

@swekshakumarisharma3899 Ай бұрын

I am getting an error of (run-time error '424': object required). How to rid this error?

@Sarfoo93 2 жыл бұрын

I have a set of data from which I want to extract some specific data using Form. I mean to say whatever I search in the Form fields will get that only data. How to make that macro

@khanabdulaziz7682 10 ай бұрын

Himanshu, as I proceed and tried to run all the VBA formula it is showing debug to me with error "1004". What am I suppose to do to resolve this

@eng.a Жыл бұрын

Sooooo useful thank you so much 👏🏻👏🏻

@rehangulshaable Жыл бұрын

Thank you very much

@Skf3175 3 ай бұрын

Thank u very much

@lawbow 2 жыл бұрын

Once i paid $67, any extra or additional money that i have to pay for, like getting new templates or animations, or version upgrade... etc ???

@jhonwilfreddrio5908 4 жыл бұрын

HELLOOOOOO!!!! When I run it, It always says "run-time error '1004': Application-defined or object-defined error" then it highlights the codes under the submit button the "Range("A1").End(xlDown).Offset(1, 0).Value = Range("a1").End(xlDown).Value + 1" is there something Wrong???

@MissFiorella1 4 жыл бұрын

THE SAME HAPPEN TO ME! :/

@janakiraman4667 4 жыл бұрын

@@MissFiorella1 SAME ERROR - UNABLE TO FIX

@trainingbyhimanshu 4 жыл бұрын

There should be one entry.. it's because there is no entry below the titles

@peterbond5888 4 жыл бұрын

@@trainingbyhimanshu Hello Himanshu, thank you for teaching me. Please where have to be the "entry"? Please show me the full Code that I can run it. Thx

@xstanley999 4 жыл бұрын

@@trainingbyhimanshu Same it Doesn't work

@kapaunkelo6939 4 жыл бұрын

Where can i find the video before this one..i want to know how did you start from the begining

@trainingbyhimanshu 4 жыл бұрын

Go to my channel and check the playlist. You will find macro playlist.. go ahead and start learning. You may click on the link here as well kzfaq.info/sun/PLTapRnxwDnt2cIjpcOWi0WZStDheCm8Fc

@kapaunkelo6939 4 жыл бұрын

@@trainingbyhimanshu I can't find the video, that you showed , how you created Name, scholarship etc, and how you entered the first entry.

@olanan1 5 жыл бұрын

Excelente Sir please more examples

@ravikumarayapilla8750 4 жыл бұрын

Excellent video sir.thank you very much sir

@trainingbyhimanshu 4 жыл бұрын

Welcome dear

@faris-math 3 жыл бұрын

Very good

@sagigi22 11 ай бұрын

By the way... Can I save one form entry to more than one row or to more than one sheet?

@sanjumondal8666 2 жыл бұрын

Thanks for this video

@nalathelion2530 3 жыл бұрын

Hi, can we add this vba into existing table? I mean a table that already has the data but i want to make it simpler for the next data entry. Thank you

@trainingbyhimanshu 3 жыл бұрын

Yes you can

@julzsynder Жыл бұрын

hi im using macbook Micorosoft excel ver. 16.66.1 i cant use userform or form option

@ShinShiomitsu 4 жыл бұрын

Thank you so much! I get the following on "Range("A7").End(xlDown).Offset(1, 0).Value = Range("A7").End(xlDown).Offset(1, 0).Value + 1" Run-time error '1004'. Application-defined or operation-defined error. Do you know why?

@trainingbyhimanshu 4 жыл бұрын

Probably a7 is the last cell where you have filled data.. cell reference give A1.

@aditimachale6050 3 жыл бұрын

@@trainingbyhimanshu Even Im getting the same problem I have written A1 still

@aditimachale6050 3 жыл бұрын

Did you find a solution to this

@ricaspinto 3 жыл бұрын

Same problem.

@shazaibshoukath 2 жыл бұрын

Guys let me make it clear that a developer first seen the code n then try to understand . So first see this video in detail it's an small miss over on your line where you have mentioned offset again after comparing the same line your code would be # = Range("A7").End(xlDown).value + 1 # Apply this after (=) equals Happy codeing 😊👍🏻

@girishmuddebihalkar3804 3 жыл бұрын

Hi I am getting error in debugg at range (a1)......... I.e first line itself what to do. Mine are all text box

@xlfreebee2862 4 жыл бұрын

Hi Himanshu, Thank you for explaining how to work with user form, I may need some help, this code works fine only if have data in row 2 or it is showing error can you details about this. Regards P V Ravi Kumar

@giovannileonemedici7282 6 жыл бұрын

Bravo!

@priyankanalwa1069 15 күн бұрын

How to save this worksheet

@jankeessteenbergen 3 жыл бұрын

hero

@kannadaspardhalokakalaburg9565 Жыл бұрын

plz introduce each tab menu tools in user form menu

@prashantthawani9658 3 жыл бұрын

Sir whenever I make the userform there are always 1004 error occurred. Will you please tell me how to remove that error.

@ziasalem4469 2 жыл бұрын

THANKS, A LOT HOW CAN FIND THE FORM WHEN WE CREATE A FORM IN EXCEL SHEET WHEN I CLOSE MY FORM AFTER CLOSED AND COME OPEN THE FILE THE FORM DO NOT SHOW ON THE SHEET

@trainingbyhimanshu 2 жыл бұрын

Save the file as a macro enabled workbook

@user-zv2vj6ie8f 3 жыл бұрын

First of all I must say Very thank you. Its all working but how can i save file with recorded macros after save and close my all macros couldn’t work. Please say me that how can i use recorded macro after save the file

@trainingbyhimanshu 3 жыл бұрын

Save it as macro enabled workbook...

@santoshpatel3965 4 жыл бұрын

Thank u 😉

@trainingbyhimanshu 4 жыл бұрын

Welcome

@jawadmalik4350 Жыл бұрын

is visual basic coding is difficult to learn

@sujitsk Жыл бұрын

Thank you for a very educative session Himanshu 🙏

@Mzayn671 3 жыл бұрын

Range("A1").End(xlDown).Offset(1, 0).Value = Range("A1").End(xlDown).Value + 1 this line doesn't work out in mine. u know why?

@trainingbyhimanshu 3 жыл бұрын

You need to do atleast one entry manually in your data to make it work.

@tankusaikia6162 2 жыл бұрын

Same here and i did enter a data manually

@user-db5ih3bl7c 2 жыл бұрын

I have error: Compile error: Variable not defined What shall I do?

@incredibleeazzi3560 2 жыл бұрын

Trying your method, I faced a challenge with the coding for textbox 1 Can you review it for me pls But you did a great job

@user-xm6rc9ym8v Жыл бұрын

nice video, but your audio is very very low...

@knight7466 Жыл бұрын

W video

@davidemedina5492 Жыл бұрын

Diculpa los que estan de color verde el texto el contenido para colocar en el centro como se hace?

@pratikshaaangane7563 2 жыл бұрын

@AA-de1rl 3 жыл бұрын

Hello sir I have an an issue in my college project which is due today Can I email you the file please ?

@AA-de1rl 3 жыл бұрын

If anyone can help me I would appreciate it very much

@azhadshamim3122 2 жыл бұрын

Sir, How to run a userform in Windows 2007

@peacefuldisaster3851 6 жыл бұрын

Hey sir, Thanx for all this tutorials I want coding for a "textbox in a userform" named as OUTPUT which provides combined data with separater like ", or / " of all the above "textboxes and combobox of same userform" and then by clicking on command button "DONE"....it will paste the output item in excel. Please sir provide a solution for it...

@trainingbyhimanshu 6 жыл бұрын

SHAITAAN I have not got the question?? Explain it again..

@peacefuldisaster3851 6 жыл бұрын

I Turn i have created a userform in which i used 4 textboxes nd 5 combobox... nd in d last i add a lable "output" with 5th Textbox... now in that last textbox i need all the data which is entered in the above text and combo boxes... and when i get that data in textbox I want to use a button to transfer the same data to worksheet selected range...

@trainingbyhimanshu 6 жыл бұрын

SHAITAAN double click on userform.. in the command prompt type textbox5.value = the output.. Create another command button and give a name like transfer. Double click on command button and type Range("a2").value = textbox5.value In place of A2 give your preferred cell reference.. Hope it will help..if still facing problem mail the file to himanshu@iturninstitute.com.. I will check..

@peacefuldisaster3851 6 жыл бұрын

I Turn hey... i ll send u the file with all the details in 5 mins....thanx a lot for reply... :)

@peacefuldisaster3851 6 жыл бұрын

I Turn mail sent on ur id... :)

@ankitkothari5675 3 жыл бұрын

I am getting runtime error on ->Range("a1").End(x1Down).Offset(1, 0).Value = Range("a1").End(x1Down).Value + 1 Run-time error '1004'. Application-defined or operation-defined error.

@trainingbyhimanshu 3 жыл бұрын

Do atleast one entry in your data manually to avoid this error

@utsavgoyal7454 3 жыл бұрын

Facing the same error, and i did enter one entry manually

@aditimachale6050 3 жыл бұрын

Did you find any solution for this

@utsavgoyal7454 3 жыл бұрын

@@aditimachale6050 Watch some another video, he is skipping some steps

@aditimachale6050 3 жыл бұрын

@@utsavgoyal7454 okay thanks do you know any?

@kajalkestwal7740 4 жыл бұрын

How to open userform inn just one click on command????

@trainingbyhimanshu 4 жыл бұрын

One click or command? Click base I have told already in the video

@minekillgaming 3 жыл бұрын

compile error invalid outside procedure

@trainingbyhimanshu 3 жыл бұрын

What's the code

@tibhilmathew4394 6 жыл бұрын

please help me i have a serious issue with excel .my colleague excel always gets close by itself .then all the data is lost .....please email me the solution

@trainingbyhimanshu 6 жыл бұрын

Tibhil Mathew kindly clarify whether its one particular excel file or all the excel file in his system?

@tibhilmathew4394 6 жыл бұрын

I Turn this happens only at certain times and certain excel will close after showing not responding screen

@trainingbyhimanshu 6 жыл бұрын

That's an application problem.. reinstall ms office package

@tibhilmathew4394 6 жыл бұрын

I Turn i have already Done that.

@tibhilmathew4394 6 жыл бұрын

sometimes when the workbook is ope and we are using and it shows as not responding and get close by itself and that is an accounts pc and he has lots of entry which he has to redo everytime.very hard ..please help me .. this happens with excel only no other application in that pc have this issue .please help you...

@SA95712_editz Ай бұрын

It's not working

@rayhanulislam4104 Жыл бұрын

Code doesn’t work

@khalidmajeed2886 2 ай бұрын

sir awaz bohat slow haay

@ahmadzaki6655 2 жыл бұрын

Berusaha untuk maksud walaupun nilai bing gua E

@aparnamahata3091 2 жыл бұрын

Runtime error 1004

@Vikashkumar-jz9jv 2 жыл бұрын

it does not work

@girikkaushik8070 2 жыл бұрын

thoda tez bol lea kr

@Sarfoo93 2 жыл бұрын

You should more laud

@baljitsinghsaimbi8234 2 жыл бұрын

First, Thanks to Himanshu for putting this together. This was the seed of the idea generation. Like most of the guys, I was also getting error while compiling this code : Range("a1").End(x1Down).Offset(1, 0).Value = Range("a1").End(x1Down).Value + 1 >>> Run-time error '1004'. Application-defined or operation-defined error.

@blaze9525 2 жыл бұрын

Couldn’t get this to work either. Kept getting “subscript out of range” error

@blaze9525 2 жыл бұрын

I don’t know if VBA changed, but just put: set dblist = Sheet1 iRow = Sheet1.Range(“A1048576”).End(xlUp).Row + 1 DON’T do that Sheets(“Sheet1”) thing - it’ll give error code 9 It blows my mind that it’s so hard to make use of this content in the real world. Altogether I’ve wasted like 3 hours on this incredibly banal task. Ridiculous. This nonsense is why I loathe writing in VBA and very much look forward to not having to touch it again in a few days. Good grief.