{"id":224493,"date":"2023-12-17T14:34:53","date_gmt":"2023-12-17T14:34:53","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/"},"modified":"2023-12-17T14:34:53","modified_gmt":"2023-12-17T14:34:53","slug":"how-to-sum-textbox-values-using-inputbox-in-vba","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/","title":{"rendered":"How to sum textbox values using InputBox in VBA?"},"content":{"rendered":"<p>If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various textboxes. One way to achieve this is by using the InputBox function in VBA. By utilizing this function along with the appropriate code, you can perform the addition of textbox values easily. This article will guide you through the process of summing textbox values using InputBox in VBA.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#Step_1_Define_the_Textboxes\" title=\"Step 1: Define the Textboxes\">Step 1: Define the Textboxes<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#How_to_sum_textbox_values_using_InputBox_in_VBA\" title=\"How to sum textbox values using InputBox in VBA?\">How to sum textbox values using InputBox in VBA?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#1_How_do_I_restrict_the_user_to_input_only_numeric_values_in_the_InputBox\" title=\"1. How do I restrict the user to input only numeric values in the InputBox?\">1. How do I restrict the user to input only numeric values in the InputBox?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#2_Can_I_sum_decimal_values_entered_in_the_textboxes\" title=\"2. Can I sum decimal values entered in the textboxes?\">2. Can I sum decimal values entered in the textboxes?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#3_Is_there_a_maximum_number_of_textboxes_that_can_be_entered\" title=\"3. Is there a maximum number of textboxes that can be entered?\">3. Is there a maximum number of textboxes that can be entered?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#4_Can_I_sum_values_from_textboxes_stored_in_an_array\" title=\"4. Can I sum values from textboxes stored in an array?\">4. Can I sum values from textboxes stored in an array?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#5_How_can_I_handle_cases_when_non-numeric_values_are_entered\" title=\"5. How can I handle cases when non-numeric values are entered?\">5. How can I handle cases when non-numeric values are entered?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#6_Can_I_sum_the_textboxes_without_using_an_InputBox\" title=\"6. Can I sum the textboxes without using an InputBox?\">6. Can I sum the textboxes without using an InputBox?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#7_Is_it_possible_to_sum_a_subset_of_the_entered_textbox_values\" title=\"7. Is it possible to sum a subset of the entered textbox values?\">7. Is it possible to sum a subset of the entered textbox values?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#8_What_happens_if_the_user_doesnt_enter_any_values_in_the_InputBox\" title=\"8. What happens if the user doesn&#8217;t enter any values in the InputBox?\">8. What happens if the user doesn&#8217;t enter any values in the InputBox?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#9_Can_I_sum_the_textbox_values_from_a_specific_range\" title=\"9. Can I sum the textbox values from a specific range?\">9. Can I sum the textbox values from a specific range?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#10_Can_I_sum_both_positive_and_negative_values\" title=\"10. Can I sum both positive and negative values?\">10. Can I sum both positive and negative values?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#11_Will_the_code_handle_large_numbers_efficiently\" title=\"11. Will the code handle large numbers efficiently?\">11. Will the code handle large numbers efficiently?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#12_How_can_I_use_the_result_in_further_calculations_instead_of_displaying_it_in_a_message_box\" title=\"12. How can I use the result in further calculations instead of displaying it in a message box?\">12. How can I use the result in further calculations instead of displaying it in a message box?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Step_1_Define_the_Textboxes\"><\/span>Step 1: Define the Textboxes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we proceed with summing the values, we need to create the textboxes in your VBA userform. To do this, you can follow these steps:<\/p>\n<ol><\/p>\n<li>Open the VBA editor by pressing <b>Alt+F11<\/b> in Excel.<\/li>\n<p><\/p>\n<li>Insert a <b>UserForm<\/b> by going to <b>Insert > UserForm<\/b>.<\/li>\n<p><\/p>\n<li>In the toolbox, select the <b>Textbox<\/b> control and draw a TextBox on the UserForm.<\/li>\n<p><\/p>\n<li>Repeat the previous step to create as many textboxes as needed for your application.<\/li>\n<p>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"How_to_sum_textbox_values_using_InputBox_in_VBA\"><\/span>How to sum textbox values using InputBox in VBA?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo sum the values entered in the textboxes using an InputBox, you can include the following steps in your VBA code:<\/p>\n<ol><\/p>\n<li>Declare a variable to hold the sum:<\/li>\n<p>&#8220;`<br \/>\nDim total As Double<br \/>\n&#8220;`<\/p>\n<li>Prompt the user to enter the values:<\/li>\n<p>&#8220;`<br \/>\nDim inputValues As String<br \/>\ninputValues = InputBox(&#8220;Enter the values to sum (separated by commas):&#8221;)<br \/>\n&#8220;`<\/p>\n<li>Split the input string into an array:<\/li>\n<p>&#8220;`<br \/>\nDim valuesArray() As String<br \/>\nvaluesArray = Split(inputValues, &#8220;,&#8221;)<br \/>\n&#8220;`<\/p>\n<li>Iterate through the array and sum the values:<\/li>\n<p>&#8220;`<br \/>\nFor Each value In valuesArray<br \/>\n    total = total + CDbl(value)<br \/>\nNext value<br \/>\n&#8220;`<\/p>\n<li>Display the total:<\/li>\n<p>&#8220;`<br \/>\nMsgBox &#8220;The sum of the values is: &#8221; &#038; total<br \/>\n&#8220;`\n<\/ol>\n<p>By following these steps, you will be able to efficiently sum the textbox values using an InputBox in VBA.<\/p>\n<p>Now, let&#8217;s address some related frequently asked questions:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_How_do_I_restrict_the_user_to_input_only_numeric_values_in_the_InputBox\"><\/span>1. How do I restrict the user to input only numeric values in the InputBox?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo ensure that the user only enters numeric values, you can add validation to your code using functions like IsNumeric or regular expressions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Can_I_sum_decimal_values_entered_in_the_textboxes\"><\/span>2. Can I sum decimal values entered in the textboxes?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can sum decimal values by declaring the total variable as Double and casting each textbox value to Double when performing the addition.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Is_there_a_maximum_number_of_textboxes_that_can_be_entered\"><\/span>3. Is there a maximum number of textboxes that can be entered?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, there is no specific limit to the number of textboxes that can be entered. You can use as many textboxes as required for your application.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Can_I_sum_values_from_textboxes_stored_in_an_array\"><\/span>4. Can I sum values from textboxes stored in an array?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can store the textbox values in an array and then sum them by iterating through the array, similar to the example provided.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_can_I_handle_cases_when_non-numeric_values_are_entered\"><\/span>5. How can I handle cases when non-numeric values are entered?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo handle non-numeric values, you can use error handling mechanisms such as the On Error statement or perform validation to check if each value is numeric before adding it to the sum.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_I_sum_the_textboxes_without_using_an_InputBox\"><\/span>6. Can I sum the textboxes without using an InputBox?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can sum the values directly entered in textboxes without using an InputBox. You can retrieve the values by referring to the respective textbox controls on your UserForm.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Is_it_possible_to_sum_a_subset_of_the_entered_textbox_values\"><\/span>7. Is it possible to sum a subset of the entered textbox values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can modify the code to sum a specific subset of the entered textbox values by applying conditions or using indices while iterating through the array.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_What_happens_if_the_user_doesnt_enter_any_values_in_the_InputBox\"><\/span>8. What happens if the user doesn&#8217;t enter any values in the InputBox?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf the user clicks Cancel or leaves the input box blank, the inputValues variable will be an empty string, which won&#8217;t be split into any array elements, resulting in a sum of zero.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_sum_the_textbox_values_from_a_specific_range\"><\/span>9. Can I sum the textbox values from a specific range?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can modify the code to reference a specific range of textboxes by adjusting the code that retrieves the values or specifying the range through index numbers or object names.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_I_sum_both_positive_and_negative_values\"><\/span>10. Can I sum both positive and negative values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, the provided code sums both positive and negative values. The total variable will reflect the sum of all the entered values, regardless of their sign.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Will_the_code_handle_large_numbers_efficiently\"><\/span>11. Will the code handle large numbers efficiently?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, VBA is capable of handling large numbers efficiently, so the provided code will work seamlessly even with large sums or numeric values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_How_can_I_use_the_result_in_further_calculations_instead_of_displaying_it_in_a_message_box\"><\/span>12. How can I use the result in further calculations instead of displaying it in a message box?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo use the result in further calculations, you can assign the sum value to a variable and perform any necessary calculations or use it for subsequent operations within your VBA code.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various textboxes. One way to achieve this is by using the InputBox function in VBA. By utilizing this function along with the appropriate code, you can perform the addition of textbox &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to sum textbox values using InputBox in VBA?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#more-224493\">Read more<span class=\"screen-reader-text\">How to sum textbox values using InputBox in VBA?<\/span><\/a><\/p>\n","protected":false},"author":56,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-224493","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to sum textbox values using InputBox in VBA?<\/title>\n<meta name=\"description\" content=\"If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to sum textbox values using InputBox in VBA?\" \/>\n<meta property=\"og:description\" content=\"If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-17T14:34:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sarah Prince\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sarah Prince\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/\"},\"author\":{\"name\":\"Sarah Prince\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/80e5190de9e3c306f162d2194af9fcec\"},\"headline\":\"How to sum textbox values using InputBox in VBA?\",\"datePublished\":\"2023-12-17T14:34:53+00:00\",\"dateModified\":\"2023-12-17T14:34:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/\"},\"wordCount\":749,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/\",\"name\":\"How to sum textbox values using InputBox in VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-12-17T14:34:53+00:00\",\"dateModified\":\"2023-12-17T14:34:53+00:00\",\"description\":\"If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to sum textbox values using InputBox in VBA?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/80e5190de9e3c306f162d2194af9fcec\",\"name\":\"Sarah Prince\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Sarah Prince\"},\"description\":\"Guest author Sarah Prince has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to sum textbox values using InputBox in VBA?","description":"If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/","og_locale":"en_US","og_type":"article","og_title":"How to sum textbox values using InputBox in VBA?","og_description":"If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various","og_url":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-12-17T14:34:53+00:00","og_image":[{"width":500,"height":164,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","type":"image\/png"}],"author":"Sarah Prince","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Sarah Prince","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/"},"author":{"name":"Sarah Prince","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/80e5190de9e3c306f162d2194af9fcec"},"headline":"How to sum textbox values using InputBox in VBA?","datePublished":"2023-12-17T14:34:53+00:00","dateModified":"2023-12-17T14:34:53+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/"},"wordCount":749,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/","url":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/","name":"How to sum textbox values using InputBox in VBA?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-12-17T14:34:53+00:00","dateModified":"2023-12-17T14:34:53+00:00","description":"If you are working with Visual Basic for Applications (VBA), you might come across situations where you need to sum the values entered in various","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-sum-textbox-values-using-inputbox-in-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to sum textbox values using InputBox in VBA?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/80e5190de9e3c306f162d2194af9fcec","name":"Sarah Prince","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Sarah Prince"},"description":"Guest author Sarah Prince has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/224493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/56"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=224493"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/224493\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=224493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=224493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=224493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}