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.
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 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.
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
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.
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?
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 😊👍🏻
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
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
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
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.
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.
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 ua-cam.com/play/PLTapRnxwDnt2cIjpcOWi0WZStDheCm8Fc.html
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???
@@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
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...
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...
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..
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.
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
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...
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!
Thats Awesome. I have created an userform with this video for my daily business. My sincere gratitude to you
Thanks
Sir, thank u very much for ur easily graspable way of teaching strategy.. much appreciated...
Thank you very much. I do appreciate your patience and clear explanation. Keep up the good work
Thank you
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.
You may try this
Range("a1048576").End(xlup).offset(1,0).value.. with this method a single entry is not needed.
Thanks alot sir i have created customer userform with help of your video 👍 for my project❤
Thank you for the lesson, you, Sir, are so easy to follow makes this learning p;process fun....nicely done...
Thank you for for a lesson Mr.
Hi Himanshu,
it's a really simple and better way of starting the Userforms
thanks for sharing your knowledge
You're the best... I follow all your steps.. it's work..
Thank you !
I have made this form for my institute project.
thank God you exist
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
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
Thanks for your tutorial very understand me and easy
Thank you for the lesson
Thank you very much. This Video helps me a lot.
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.
Unique explanation 👌 I have understood everystood you go by..Thanks
Thank you
Thanks buddy for creating this tutorial !!
this is a great beginner tutorial for creating forms
Really helpful. Thanks Himanshu!
Great tutorial. Thanks!
Very Useful, Thank you
It's very nice and easy also thank you sir 😊
Thank You
Thank you so much. I was trying to find a way to do this on TypeScript but it would not show drop-downs.
Thank you very much
Sooooo useful thank you so much 👏🏻👏🏻
Thanks for this video
Excellent video sir.thank you very much sir
Welcome dear
Thank you for a very educative session Himanshu 🙏
By the way...
Can I save one form entry to more than one row or to more than one sheet?
plz introduce each tab menu tools in user form menu
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
There should be atleast 1 entry in that data. I mean below the Headings do one entry manually then only it will work.
@@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.
Excelente Sir please more examples
Very good
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
Yes you can
I am getting an error of (run-time error '424': object required). How to rid this error?
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
How to save this worksheet
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.
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?
Probably a7 is the last cell where you have filled data.. cell reference give A1.
@@trainingbyhimanshu
Even Im getting the same problem
I have written A1 still
Did you find a solution to this
Same problem.
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 😊👍🏻
Thank u 😉
Welcome
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
Save it as macro enabled workbook...
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
Bravo!
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
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 ???
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
Save the file as a macro enabled workbook
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.
Couldn’t get this to work either. Kept getting “subscript out of range” error
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.
Where can i find the video before this one..i want to know how did you start from the begining
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
ua-cam.com/play/PLTapRnxwDnt2cIjpcOWi0WZStDheCm8Fc.html
@@trainingbyhimanshu I can't find the video, that you showed , how you created Name, scholarship etc, and how you entered the first entry.
hi im using macbook Micorosoft excel ver. 16.66.1 i cant use userform or form option
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
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???
THE SAME HAPPEN TO ME! :/
@@MissFiorella1 SAME ERROR - UNABLE TO FIX
There should be one entry.. it's because there is no entry below the titles
@@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
@@trainingbyhimanshu Same it Doesn't work
Hi I am getting error in debugg at range (a1)......... I.e first line itself what to do. Mine are all text box
is visual basic coding is difficult to learn
hero
Diculpa los que estan de color verde el texto el contenido para colocar en el centro como se hace?
nice video, but your audio is very very low...
Tx
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...
SHAITAAN I have not got the question?? Explain it again..
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...
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..
I Turn hey... i ll send u the file with all the details in 5 mins....thanx a lot for reply... :)
I Turn mail sent on ur id... :)
Sir, How to run a userform in Windows 2007
Sir whenever I make the userform there are always 1004 error occurred. Will you please tell me how to remove that error.
I have error:
Compile error:
Variable not defined
What shall I do?
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?
You need to do atleast one entry manually in your data to make it work.
Same here and i did enter a data manually
Hello sir
I have an an issue in my college project which is due today
Can I email you the file please ?
If anyone can help me I would appreciate it very much
How to open userform inn just one click on command????
One click or command?
Click base I have told already in the video
W video
sir awaz bohat slow haay
compile error invalid outside procedure
What's the code
Submit button Not working, Run-time error '1004'
same to me
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.
Do atleast one entry in your data manually to avoid this error
Facing the same error, and i did enter one entry manually
Did you find any solution for this
@@aditimachale6050 Watch some another video, he is skipping some steps
@@utsavgoyal7454 okay thanks do you know any?
It's not working
Code doesn’t work
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
Tibhil Mathew kindly clarify whether its one particular excel file or all the excel file in his system?
I Turn this happens only at certain times and certain excel will close after showing not responding screen
That's an application problem.. reinstall ms office package
I Turn i have already Done that.
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...
Berusaha untuk maksud walaupun nilai bing gua E
Runtime error 1004
it does not work
thoda tez bol lea kr
You should more laud
Thank u very much