This is what a tutorial is all really about, Explaining the basic, Doing an Example and executing it on different levels. This is what a really Teaching should be on coding not a robot machine who memorize syntax without understanding anything.
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Thanks that's exactly what I'm looking for! But how should I try to put it into my Userform instead of Sheet 1? Which Object and Procedure in Userform?
Hey this is fantastic I was able to create a where user will be able to check data entry error soon they finished entering the last digit fab I wonder you could solve this problem for me . here we are ... I created a data entry form and linked the database below so that user can select a particular row and then edit or delete so far so good The issue is I want to make this list to be in descending order and as and when a new row of data is entered this appear right at the top so that the user know what is the last piece of data entered
if we want system to calculate the text boxes and divide it total value with the number of text boxes are available, how we can do that? please help....!!!!!
Boss, wanna ask a question? Is it possible to add the two labels value together? I've tried it but it wont auto calculate..only can calculated it when i ran it in the dev tab..
Can you help me with the following please: I created a Userform with 14 Textboxes. T1...T12 for data entry(numeric value only). T13 : Sum of T1...T12 (It’s ok for that one.) How can I get the Average automatically in T14, counting non blank textboxes?
Hi Dan, Greatings from Belgium. I am trying to make a foodcost application with excel for my restaurant. I figured out the most, but i am stuck on the calculations. Having trouble with decimals. Here in Belgium we write 1.200 instead of 1.200,00. My formule won't pick up numbers after the decimals, or won't even insert a decimal. i tried val(me.textbox) or format(textbox). i tried this tutorial. Really i can not figure it out. Please can i send you the excel file so you can have a look at it. If you could just help me 1 step. Thanks in advance. if you agree that i can send you the excel file, where do i send it. please please.
Hey there i know this video is a little old but I just found it and wow its helped me so much. I am having to build a program that does various things for a final. I am having a problem though. I have a userform with two textboxes. when the user clicks add it adds the two together and displays in a label. I used the IIF statement with a msgbox ("please enter a number into the first box") if the txtbox comes back "". here is my code. could you help me out please? the msgbox displays, but all the time whether the txtbox is numeric or not. lblCalcAnswer = "Your numbers added together are " & (IIf(txtCalc1 = "", MsgBox("Please enter a number into the first box"), _ txtCalc1)+ 0) + (IIf(txtCalc2 = "", MsgBox("Please enter a number into the second box"), txtCalc2) + 0)
+Tomáš Kochan The same question here. But on me, how can it be done to make the total updates as the textboxes were updated too. Let us say there are 10 textboxes to add. thank you . I am your fan
This is what a tutorial is all really about, Explaining the basic, Doing an Example and executing it on different levels. This is what a really Teaching should be on coding not a robot machine who memorize syntax without understanding anything.
This was JUST what I needed. Thank you!!! Made my week!
thank you very much, you let it look soo easy
Dude this helped me soo much for my VBA form for my unit assignment, thanks man..
So Glad I could help! Thanks for the kind words, Thomas!
Dan....brilliant video..loved it!!!
Awesome! Thanks MYJETGLO!! I appreciate that! Dan
Really helpful. Thanks man!
Great Job
Thanks Carl!!
Thank you, this tutorial really help me to do some cool stuffs. Greatings from CHILE.
Jajakallahi khairan
wow!! this video is great & helpful! thanks
Sir thank you very much for excellent and very interesting lesson
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Very nice sir
This is a great video.. thanks for sharing
Thnks
this video really helped! thanks soo much!
Awesome! Glad that helps, Nailea! Don't forget to sign up for my FREE ebook. www.excelvbaisfun.com/free-ebook.html
Thanks that's exactly what I'm looking for! But how should I try to put it into my Userform instead of Sheet 1? Which Object and Procedure in Userform?
this only need, thanks a lot
Thanks buddy..
It works!
Hey this is fantastic I was able to create a where user will be able to check data entry error soon they finished entering the last digit fab
I wonder you could solve this problem for me . here we are ... I created a data entry form and linked the database below so that user can select a particular row and then edit or delete so far so good The issue is I want to make this list to be in descending order and as and when a new row of data is entered this appear right at the top so that the user know what is the last piece of data entered
Please provide the code sir
thank you so much
Thanks dear
Very welcome, K K!
if we want system to calculate the text boxes and divide it total value with the number of text boxes are available, how we can do that? please help....!!!!!
how would I find this workbook
What if you want to add the values of 10 or more textboxes?
Very nice...
Thanks, Urmila!
Boss, wanna ask a question? Is it possible to add the two labels value together? I've tried it but it wont auto calculate..only can calculated it when i ran it in the dev tab..
How to 50 textbox value sum plz solved
u r superhero
Thanks for the support
How to get answer with no command button.
Can you help me with the following please:
I created a Userform with 14 Textboxes.
T1...T12 for data entry(numeric value only).
T13 : Sum of T1...T12 (It’s ok for that one.)
How can I get the Average automatically in T14, counting non blank textboxes?
Please see new vid th-cam.com/video/XwrKZ4TMO-w/w-d-xo.html
Hi Dan, Greatings from Belgium. I am trying to make a foodcost application with excel for my restaurant. I figured out the most, but i am stuck on the calculations. Having trouble with decimals. Here in Belgium we write 1.200 instead of 1.200,00. My formule won't pick up numbers after the decimals, or won't even insert a decimal. i tried val(me.textbox) or format(textbox). i tried this tutorial. Really i can not figure it out. Please can i send you the excel file so you can have a look at it. If you could just help me 1 step. Thanks in advance. if you agree that i can send you the excel file, where do i send it. please please.
Hey there i know this video is a little old but I just found it and wow its helped me so much. I am having to build a program that does various things for a final. I am having a problem though. I have a userform with two textboxes. when the user clicks add it adds the two together and displays in a label. I used the IIF statement with a msgbox ("please enter a number into the first box") if the txtbox comes back "". here is my code. could you help me out please? the msgbox displays, but all the time whether the txtbox is numeric or not.
lblCalcAnswer = "Your numbers added together are " & (IIf(txtCalc1 = "", MsgBox("Please enter a number into the first box"), _
txtCalc1)+ 0) + (IIf(txtCalc2 = "", MsgBox("Please enter a number into the second box"), txtCalc2) + 0)
How to put value in both textbox without helping mouse
Hi! Maybe off this topic, but how could you make it jump from one textbox to another by hitting TAB key? Anyways, nice video !
+Tomáš Kochan
The same question here. But on me, how can it be done to make the total updates as the textboxes were updated too. Let us say there are 10 textboxes to add. thank you . I am your fan
Hi there. Can someone help me please?
Check out our new vid please. :)
the fucking best video i have ever seen
Thanks so much! Lots more here on the channel. Lots of premium stuff at excelvbaisfun.com
Thanks!!
Opps..sorry, actually ive made two using the same code...meaning i have two labels