+ Reply to Thread
Results 1 to 3 of 3

calculation by userform based on selected combobox to summing or subtraction

  1. #1
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    calculation by userform based on selected combobox to summing or subtraction

    Hello
    I want matching selected comboboxes on userform with sheet B: E and summing or subtraction based on selected from combobox 13
    so the numbers for comboboxes & textboxes will be for each row on userform like this
    combobox1 combobox2 combobox3 combobox4 ,textbox1
    combobox5 combobox6 combobox7 combobox8,textbox2
    combobox9 combobox10 combobox11 combobox12,textbox3


    so when select SALES from combobox 13 SALES and fill userfrom as in CON1 sheet
    so should subtract the QTY from textboxes to column F


    when select RET1 from combobox 13 as in CON2 sheet
    so should subtract the QTY from textboxes to column F




    when select PURCHASE from combobox13 and fill userfrom as in CON3 sheet

    so should summing the QTY from textboxes to column F
    to become in column F



    when select when select RET2 from combobox13 as in as in CON4 sheet

    so should summing the QTY from textboxes to column F
    to become in column F


    so I put the cases in sheets(con1,2,3,4)
    also I posted here
    https://www.mrexcel.com/board/thread...ction.1238449/
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: calculation by userform based on selected combobox to summing or subtraction

    could achieve this ?

  3. #3
    Forum Contributor
    Join Date
    07-14-2021
    Location
    LY
    MS-Off Ver
    2019
    Posts
    271

    Re: calculation by userform based on selected combobox to summing or subtraction

    no answering so far

+ 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. [SOLVED] summing duplicates elements into textboxes on userform based on combobox , spinbutton
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2022, 02:49 PM
  2. How do I add a selected range of value from combobox in userform?
    By Toomer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2019, 06:45 AM
  3. [SOLVED] populate sheet based on criteria selected in userform combobox.
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2019, 04:00 PM
  4. [SOLVED] Userform - ListBox items added based on Combobox value selected
    By jayherring86 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-12-2014, 09:12 AM
  5. [SOLVED] Pass Value of combobox selected in Userform as input to textbox of other userform
    By Pradeepg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 10:32 AM
  6. Update Rows in Database based on Combobox selected item on Userform. Problem .
    By jmarriott in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-09-2013, 01:08 PM
  7. Edit a selected Combobox with another userform
    By clapforthewolfman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2013, 04:20 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