+ Reply to Thread
Results 1 to 3 of 3

Sum of Combo Box and Textbox value

  1. #1
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Sum of Combo Box and Textbox value

    Hello there, I am getting crazy now as I look for the best solution for my problem. I have a combo box which is the option of Yes-1 and No-0(by change will only turn to 1 or 0), and a text box with 1 and 0 can be the value, now I want to get the total score of those value like if Combo Box is Yes(that is equivalent to 1) and textbox has a value of 1 so the total score should be 2. Any thoughts of this? I have 5 combo box and 3 textboxes need to total. Thanks.

    Hope someone can help me.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Sum of Combo Box and Textbox value

    Where are the textboxes and comboboxes located?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Sum of Combo Box and Textbox value

    @norie it was located in a form but basically I used Tab Control and put a subform calling that form with textbox and combo box.

+ 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. how to add value to textbox based combo box
    By VBAidot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2017, 09:53 AM
  2. VBA lookup value in combo box, to populate value in textbox
    By afwelch87 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2014, 11:07 AM
  3. Vlookup fom Combo Box to Textbox
    By SUNDARAM1501 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2013, 03:23 AM
  4. Populating textbox using a combo box
    By Mr.Steel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2011, 04:34 PM
  5. combo boxes values to textbox
    By albert28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2010, 04:28 AM
  6. Re: Vlookup from a combo box to bring a value to a textbox
    By anonfish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2010, 03:22 AM
  7. Excel 2007 : Placing textbox over combo box
    By kamakhyasingh in forum Excel General
    Replies: 9
    Last Post: 01-06-2009, 07:10 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