+ Reply to Thread
Results 1 to 2 of 2

VBA Code To Reset A Combo Box After Making A Change

  1. #1
    Registered User
    Join Date
    08-23-2021
    Location
    New England
    MS-Off Ver
    Office 2021 Professional
    Posts
    16

    VBA Code To Reset A Combo Box After Making A Change

    I?m trying to analyze 20 years of monthly sales figure according to various arbitrary percentages. Everything worked fine until I changed a few percentages in the combo box. I went to a combo box to save space on the worksheet. Suddenly the choices in the Combo Box did not match the revised list of percentages.

    I just started using Active X combo boxes and read today that combo boxes are not automatically updated when changes are made to the original combo box list. Erasing and starting over does not seem to clear anything.

    My combo box is free floating above cell C12.

    My combined percentages and titles are in Cells F124 to F129.

    1% Profit Decline
    1.5% Profit Decline
    2% Profit Decline
    1.5% Profit Decline
    1.75% Profit Decline
    2% Profit Decline

    Also, I would like to have a second in related drop down box over cell E14 to analyze sales increases in Cells G124 through F130.

    Could someone please provide me with some simple VBA code? I'm using Office 2021

    Thank you very much.

    (You would think Microsoft could do a better job with features like this.)

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: VBA Code To Reset A Combo Box After Making A Change

    How are you setting the values in the combobox?

    This will go a lot faster if you attach your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. help to change in VBA code, in chart making
    By rockyking in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2021, 05:43 AM
  2. Any way protect my code making them unreadable or change Language
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 72
    Last Post: 07-19-2017, 05:56 AM
  3. [SOLVED] Help with code to change the colour of textbox and reset the others
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2016, 10:26 AM
  4. Replies: 2
    Last Post: 01-13-2015, 12:17 PM
  5. VBA code for ADD and CHANGE events for Combo Box on worksheet
    By carlliebenberg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2014, 06:16 AM
  6. [SOLVED] Set picture box to change pic and reset code to do it again on click
    By Taemex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 03:38 AM
  7. [SOLVED] combo box on change code
    By frendabrenda1 in forum Excel General
    Replies: 0
    Last Post: 04-10-2006, 11:25 AM

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