Simple but very efficient code. Thank you very much sir. I tried it on my user form and the Previous and Next Buttons are working efficiently. I do appreciate your contribution to the fans of VBA code. Kindly give us more of your insightful ideas on coding forms.Cheers
Many Thanks Dinesh !. I have found an excellent Tutorial from yours on database handling " User-form to Manage Data Automatically". Excellent it has helped me in finding the solution. Many Thanks again for your excellent training videos. Kind regards. martin argimon
Hello Mr. Dinesh Sir, I am very much glad to see your vedios on youtube about excel vba. I have learnt so many things by you about excel vba. Now I have created an excel workbook in excel for my office. In this excel file I have created some rectangle shapes instead of commond buttons. But one thing is where I am still unsuccessful to coding. Thats I want when the mouse pointer shall touch/over the rectangle shape, it should change the back color of the rectangle shape.. plz help me and plz send a code for such a button.. thank you..
You have to assign the shape to a macro. This link will help: www.exceltrainingvideos.com/tag/create-database-in-excel-worksheet-using-shapes-assigned-to-macros/
sir plz help me too. I want to insert the attendance of an employee via userform, if he or she is present or absent on a particular date, I should be able to update the individual employee attendance status based on backdates too.
Just to clarify my previous email. Indeed I can 'search' with you r search feature, but what I meant is that with a click of a button "GO to record" No., it will take me to the record number that I need to go and set it as the current record, so that I can perform an action on the data. Hope I am clear.. Thanking you in advance. regards. Martin Argimon ( South Africa)
Sir; You are using your own logic to simply the task. I thought you may be using some specific VBA command to do it. Your identy is to do the task thru simplified programming statements
HI dinesh . Thanks very much for your excellent 'Fomrs" series. I have created a complete system with various tables related to each other and I have designed the forms based on your teachings, There is ONLY 1 one more 'button' that I would need to enable me to move to whatever record number I need to got to. Otherwise I need to click for ever if I need to go to record 1000 ( as an example). I can send you my excel program and/or capture the screen to show you what I mean, PLease confirm if you can help perhaps?
hello.sir this is js shanker.iam trying to develop a trading terminal in excel.IAM REQUESTING YOU please help me sir. my problem is WHEN ONE CELL VALUE(MEANS NUMBER IN THE CELL) GREATED THEN OR EQUAL TO ANOTHER CELL IN THE ROW THEN MOVE THAT ROW INTO ANOTHER SHEET,THIS CONDITION SHOULD BE APPLIED TO THAT HOLE SHEET. THANK YOU SIR
Hello Mr. Takyar I find your videos very helpful to develop a userform that I am working on. I followed your instructions on the video to "Create userforms with navigation bottoms". One of the challenges I found is that when I click on the "next" bottom I get the entries for the titles and when I click on the "back" bottom I get an error. When I click on the Debug bottom on the error it takes me to the TextBox1 = Cells (currentrow, 1). This command is the same as your video. I also do not get the message box. Can you help me?
Sir I enter the same codes in my vba but it shows the runtime error 2147417848 saying the client has been disconnected... I'm using excel 2010 on windows 7
Hello, can you help me work on the next and previous button? when the last name in the list in the worksheet then next.enable = false And when it is the first name in the list in the worksheet then previous.enable = false
Strategies described in these links will help: www.exceltrainingvideos.com/update-navigate-records-excel-worksheet-with-user-form/ www.exceltrainingvideos.com/how-to-display-multiple-charts-from-excel-worksheet-on-userform/ You can also search my website www.exceltrainingvideos.com or this TH-cam channel.
This is a very late reply 🥱🥱but remember this code is only to show how to navigate and not other aspects 😐😐. There are other videos as to how to search, update, etc.
Simple but very efficient code. Thank you very much sir. I tried it on my user form and the Previous and Next Buttons are working efficiently. I do appreciate your contribution to the fans of VBA code. Kindly give us more of your insightful ideas on coding forms.Cheers
Glad it helped. Please share with your friends too.
Thanks . You are doing great service to human kind. God bless you sir
Thank you!
Many Thanks Dinesh !. I have found an excellent Tutorial from yours on database handling " User-form to Manage Data Automatically". Excellent it has helped me in finding the solution. Many Thanks again for your excellent training videos. Kind regards. martin argimon
Glad it helped
Thank you Very much Sir...Your video really helped me!
Glad it helped
This link will also help: th-cam.com/video/Oo7AVcqPq_A/w-d-xo.html
sir your teaching style is varry easy thanks
Hello Mr. Dinesh Sir, I am very much glad to see your vedios on youtube about excel vba. I have learnt so many things by you about excel vba. Now I have created an excel workbook in excel for my office. In this excel file I have created some rectangle shapes instead of commond buttons. But one thing is where I am still unsuccessful to coding. Thats I want when the mouse pointer shall touch/over the rectangle shape, it should change the back color of the rectangle shape.. plz help me and plz send a code for such a button.. thank you..
You have to assign the shape to a macro. This link will help: www.exceltrainingvideos.com/tag/create-database-in-excel-worksheet-using-shapes-assigned-to-macros/
Thanks for every helpful ideas to improve us.
Thank You
You are smart
So nice of you. Please share the VBA solution with your buddies.
sir plz help me too. I want to insert the attendance of an employee via userform, if he or she is present or absent on a particular date, I should be able to update the individual employee attendance status based on backdates too.
Just to clarify my previous email. Indeed I can 'search' with you r search feature, but what I meant is that with a click of a button "GO to record" No., it will take me to the record number that I need to go and set it as the current record, so that I can perform an action on the data. Hope I am clear.. Thanking you in advance. regards. Martin Argimon ( South Africa)
This link will help: th-cam.com/video/TRIGxZhMhSg/w-d-xo.html
Sir;
You are using your own logic to simply the task. I thought you may be using some specific VBA command to do it.
Your identy is to do the task thru simplified programming statements
HI dinesh . Thanks very much for your excellent 'Fomrs" series. I have created a complete system with various tables related to each other and I have designed the forms based on your teachings, There is ONLY 1 one more 'button' that I would need to enable me to move to whatever record number I need to got to. Otherwise I need to click for ever if I need to go to record 1000 ( as an example). I can send you my excel program and/or capture the screen to show you what I mean, PLease confirm if you can help perhaps?
Yes, I can give it my best: takyardinesh@gmail.com
Thanks ... Thanks ... Thanks
hello.sir this is js shanker.iam trying to develop a trading terminal in excel.IAM REQUESTING YOU please help me sir. my problem is WHEN ONE CELL VALUE(MEANS NUMBER IN THE CELL) GREATED THEN OR EQUAL TO ANOTHER CELL IN THE ROW THEN MOVE THAT ROW INTO ANOTHER SHEET,THIS CONDITION SHOULD BE APPLIED TO THAT HOLE SHEET. THANK YOU SIR
May I know if UserForm2 can be renamed as Userform1?
Yes.
Hello Mr. Takyar
I find your videos very helpful to develop a userform that I am working on. I followed your instructions on the video to "Create userforms with navigation bottoms". One of the challenges I found is that when I click on the "next" bottom I get the entries for the titles and when I click on the "back" bottom I get an error. When I click on the Debug bottom on the error it takes me to the TextBox1 = Cells (currentrow, 1).
This command is the same as your video. I also do not get the message box. Can you help me?
You need to check the name of the sheet if this is different than Sheet1 than rename it en it wil work
Sir I enter the same codes in my vba but it shows the runtime error 2147417848 saying the client has been disconnected... I'm using excel 2010 on windows 7
Share your code.
Unable to access value of currentRow from code written under cmdNext button
www.exceltrainingvideos.com/create-userforms-with-navigation-buttons/
Hello, can you help me work on the next and previous button?
when the last name in the list in the worksheet then next.enable = false
And when it is the first name in the list in the worksheet then previous.enable = false
Strategies described in these links will help:
www.exceltrainingvideos.com/update-navigate-records-excel-worksheet-with-user-form/
www.exceltrainingvideos.com/how-to-display-multiple-charts-from-excel-worksheet-on-userform/
You can also search my website www.exceltrainingvideos.com or this TH-cam channel.
Sir I want search and edit buttons in VBA please tell me
www.exceltrainingvideos.com/tag/create-manage-database-with-user-form/
For more cool Excel VBA stuff search www.exceltrainingvideos.com
End(xlUp).Row Stop af 4 lines !
Solution this line :ActiveSheet.Range("a10000").End(xlUp).Row
There are many ways of doing the same thing
I am also
Unable to access global variable currentRow
www.exceltrainingvideos.com/create-userforms-with-navigation-buttons/
This userform is utter waste, sine it will not allow user to edit old entries, it will create duplicate entries as well
There are at least 10 more videos for your query. Search my channel or website: www.exceltrainingvideos.com/update-record-in-database-automatically/
This is a very late reply 🥱🥱but remember this code is only to show how to navigate and not other aspects 😐😐. There are other videos as to how to search, update, etc.