+ Reply to Thread
Results 1 to 2 of 2

Multiplying TextBox Value with Values in ListBox

  1. #1
    Registered User
    Join Date
    03-30-2017
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    54

    Post Multiplying TextBox Value with Values in ListBox

    Hi everyone

    I have a product registration spreadsheet with the fields: ID, Product type, Product Amount, Price, Total
    sales.PNG


    This data is loaded into a form by a ListBox where I search for the category in a ComboBox and click on the button to filter only the products in the respective category.
    form.PNG

    Is there any way to enter a value in the TextBox "Sold Amount" and have it multiplied with the values in my ListBox "Amount, Price and Total"?
    Multiplying .PNG

    These multiplied registrations should be recorded in my sheet: "Sales" according to the example below:

    salesregister.PNG

    Attached I am forwarding the spreadsheet.
    If anyone can help me, I will be very grateful.
    Attached Files Attached Files
    Last edited by hpernaf; 07-22-2020 at 10:27 AM.

  2. #2
    Registered User
    Join Date
    03-30-2017
    Location
    Brazil
    MS-Off Ver
    2019
    Posts
    54

    Re: Multiplying TextBox Value with Values in ListBox

    I solved the issue by creating the following Sub.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Textbox to show values when clicked items on listbox
    By Benjamin2008 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2013, 07:02 PM
  2. Multiplying a numeric value textbox by a duration value textbox
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2013, 05:05 AM
  3. [SOLVED] Filter Listbox Values based on Textbox input
    By redocs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2013, 04:59 AM
  4. [SOLVED] excel vba filter values to listbox from combobox and save edit values in textbox
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 08:42 AM
  5. combining listbox values to a textbox
    By st0kvis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2011, 06:55 AM
  6. [SOLVED]multiplying values in textbox
    By burugudug in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2010, 04:36 AM
  7. Textbox values won't place into selected Listbox rows
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-16-2010, 07:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1