+ Reply to Thread
Results 1 to 3 of 3

VBA to apply value to combobox values and sum

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    Springfield, MO
    MS-Off Ver
    2007
    Posts
    42

    VBA to apply value to combobox values and sum

    Hello,
    I have a form with many combo boxes with possible values of Never, Sometimes or Often. I need to loop through the comboboxes and apply a value to the response so that I total in a txtbox.

    Never = 0
    Sometimes = 1
    Often = 2

    I have been trying to piece code together and I don't get an error but nothing actually happens. I appreciate any help that anyone can provide me!

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 02-04-2020 at 10:26 PM. Reason: Added Code Tags

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA to apply value to combobox values and sum

    Hello jbeets,

    There are two primary ComboBox controls: MSForms and Forms. The former controls are ActiveX or OLE objects, while the latter are Excel Worksheet controls.

    Their appearance and behavior are similar but the code that controls them is not. Which controls are you using?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    07-17-2014
    Location
    Springfield, MO
    MS-Off Ver
    2007
    Posts
    42

    Re: VBA to apply value to combobox values and sum

    OLE object

+ 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] ComboBox.Clear ...displayed values in the ComboBox dissappear
    By buhnen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2016, 10:32 AM
  2. [SOLVED] Commandbutton to apply textbox/combobox values to next available row in spreadsheet
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2016, 03:30 AM
  3. ComboBox values source being changed based on another combobox selection in a UserForm
    By stephenanderson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2016, 11:12 PM
  4. [SOLVED] Userform combobox to populate RowSource for new values in combobox
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-17-2013, 01:18 PM
  5. [SOLVED] Apply form control containing macro to a combobox
    By kamaaina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2013, 12:47 AM
  6. Replies: 2
    Last Post: 09-14-2009, 08:34 AM
  7. Embed combobox and look up values based on combobox value
    By cutie4032 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2008, 01:11 PM

Tags for this Thread

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