Create Userform in Excel VBA Macro in Detail

[@annatjienankela4594]

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.

[@bokingo.chubkreino815]

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!

[@karthikeyanalagu2180]

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

[@trainingbyhimanshu]

Thanks

[@Grem305]

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

[@trainingbyhimanshu]

Thank you

[@naiks5638]

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

[@hadbarahhali6586]

thank God you exist

[@don8919-t2n]

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

[@agoezcoopral]

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

[@naveenkumardks678]

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

[@saffetaltun833]

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]

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

[@SohilShah_Melodyman]

Very clearly explained! Super informative and super helpful video! Thanks a lot for sharing!😊🙏

[@BASITKHAN-hs3ij]

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

[@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]

@@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.

[@umeshsrivastava9034]

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

[@luciferiq1428]

Thank you for the lesson

[@tejasdhaware1909]

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]

Really helpful. Thanks Himanshu!

[@rsrinivasan5591]

Thanks for your tutorial very understand me and easy

[@robbysandhu4425]

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

[@trainingbyhimanshu]

Thank you

[@PortalGroup-h1v]

Thank you for for a lesson Mr.

[@rimpyrajpoot7842]

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

[@lalitthapa4315]

Thanks buddy for creating this tutorial !!

[@venkataravikiran]

this is a great beginner tutorial for creating forms

[@deoxene]

Great tutorial. Thanks!

[@maicabookkeepingservices332]

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

[@raosatyapalrao8749]

Very Useful, Thank you

[@vinnysurfo]

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

[@eng.a]

Sooooo useful thank you so much 👏🏻👏🏻

[@sujitsk]

Thank you for a very educative session Himanshu 🙏

[@sagigi22]

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

[@amitshinghaniya616]

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

[@ShinShiomitsu]

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]

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

[@aditimachale6050]

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

[@aditimachale6050]

Did you find a solution to this

[@ricaspinto]

Same problem.

[@shazaibshoukath]

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 😊👍🏻

[@kannadaspardhalokakalaburg9565]

plz introduce each tab menu tools in user form menu

[@Sarfoo93]

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

[@nalathelion2530]

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]

Yes you can

[@jhonwilfreddrio5908]

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]

THE SAME HAPPEN TO ME! :/

[@janakiraman4667]

@@MissFiorella1 SAME ERROR - UNABLE TO FIX

[@trainingbyhimanshu]

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

[@peterbond5888]

@@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]

@@trainingbyhimanshu Same it Doesn't work

[@kapaunkelo6939]

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

[@trainingbyhimanshu]

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 kzbin.info/aero/PLTapRnxwDnt2cIjpcOWi0WZStDheCm8Fc

[@kapaunkelo6939]

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

[@julzsynder]

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

[@ziasalem4469]

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]

Save the file as a macro enabled workbook

[@tapan4253]

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.

[@ravikumarayapilla8750]

Excellent video sir.thank you very much sir

[@trainingbyhimanshu]

Welcome dear

[@lawbow]

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 ???

[@priyankanalwa1069]

How to save this worksheet

[@girishmuddebihalkar3804]

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

[@rehangulshaable]

Thank you very much

[@davidemedina5492]

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

[@xlfreebee2862]

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

[@khanabdulaziz7682]

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

[@BharathGowda-n4l]

Thank You

[@olanan1]

Excelente Sir please more examples

[@faris-math]

Very good

[@sanjumondal8666]

Thanks for this video

[@jawadmalik4350]

is visual basic coding is difficult to learn

[@peacefuldisaster3851]

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]

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

[@peacefuldisaster3851]

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]

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 [e-mail].. I will check..

[@peacefuldisaster3851]

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

[@peacefuldisaster3851]

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

[@swekshakumarisharma3899]

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

[@庄则栋-i2l]

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]

Save it as macro enabled workbook...

[@yashikajamba6454]

Im having error while copy and paste

[@santoshpatel3965]

Thank u 😉

[@trainingbyhimanshu]

Welcome

[@Mzayn671]

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]

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

[@tankusaikia6162]

Same here and i did enter a data manually

[@prashantthawani9658]

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

[@ИванБогун-ь8н]

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

[@giovannileonemedici7282]

Bravo!

[@minekillgaming]

compile error invalid outside procedure

[@trainingbyhimanshu]

What's the code

[@incredibleeazzi3560]

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

[@baljitsinghsaimbi8234]

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]

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

[@blaze9525]

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.

[@azhadshamim3122]

Sir, How to run a userform in Windows 2007

[@AA-de1rl]

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

[@AA-de1rl]

If anyone can help me I would appreciate it very much

[@ankitkothari5675]

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]

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

[@utsavgoyal7454]

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

[@aditimachale6050]

Did you find any solution for this

[@utsavgoyal7454]

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

[@aditimachale6050]

@@utsavgoyal7454 okay thanks do you know any?

[@jankeessteenbergen]

hero

[@kajalkestwal7740]

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

[@trainingbyhimanshu]

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

[@SubbuMatta-o4x]

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

[@tankusaikia6162]

Submit button Not working, Run-time error '1004'

[@Accept_Jesus_Christ]

same to me

[@tibhilmathew4394]

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]

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

[@tibhilmathew4394]

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

[@trainingbyhimanshu]

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

[@tibhilmathew4394]

I Turn i have already Done that.

[@tibhilmathew4394]

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...

[@khalidmajeed2886]

sir awaz bohat slow haay

[@rayhanulislam4104]

Code doesn’t work

[@pratikshaaangane7563]

Tx

[@SA95712_editz]

It's not working

[@ahmadzaki6655]

Berusaha untuk maksud walaupun nilai bing gua E

[@aparnamahata3091]

Runtime error 1004

[@Vikashkumar-jz9jv]

it does not work

[@knight7466]

W video

[@girikkaushik8070]

thoda tez bol lea kr

[@Sarfoo93]

You should more laud

[@Skf3175]

Thank u very much

[@ZSCOPYCENTER]

thank you