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?
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....!!!!!
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)
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..
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
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?
+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.
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!
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
thank you very much, you let it look soo easy
This was JUST what I needed. Thank you!!! Made my week!
Really helpful. Thanks man!
Thank you, this tutorial really help me to do some cool stuffs. Greatings from CHILE.
Dan....brilliant video..loved it!!!
Awesome! Thanks MYJETGLO!! I appreciate that! Dan
Great Job
Thanks Carl!!
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?
Sir thank you very much for excellent and very interesting lesson
wow!! this video is great & helpful! thanks
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....!!!!!
Jajakallahi khairan
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.
Very nice sir
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)
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..
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
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 ruclips.net/video/XwrKZ4TMO-w/видео.html
This is a great video.. thanks for sharing
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
It works!
this only need, thanks a lot
how would I find this workbook
Thanks buddy..
Thanks dear
Very welcome, K K!
What if you want to add the values of 10 or more textboxes?
Very nice...
Thanks, Urmila!
thank you so much
Thnks
Please provide the code sir
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
How to get answer with no command button.
u r superhero
Thanks for the support
How to 50 textbox value sum plz solved
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!!
How to put value in both textbox without helping mouse
Hi there. Can someone help me please?
Check out our new vid please. :)
Opps..sorry, actually ive made two using the same code...meaning i have two labels