+ Reply to Thread
Results 1 to 4 of 4

clicking activeX combobox disables worksheet

  1. #1
    Registered User
    Join Date
    04-23-2021
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2016
    Posts
    2

    clicking activeX combobox disables worksheet

    I am using Excel 2016. In one of the worksheets, I have an ActiveX combobox that contains some city names. The city names are populated when the workbook is loaded. Everything is fine up to this point. But after I click on the combobox to change the city, I cannot change the value of any cell in the worksheet. it is like the worksheet is frozen. If I go to any other worksheet then go back to the concerned worksheet, everything works fine.

    Then, I added empty Combobox in every sheet. The same thing happened once I click on the comboxbox. And again, the problem disappear when I leave the sheet to another one and go back.

    I do not know what I did wrong. Note that I tried this on a clean workbook, the problem did not occur.

  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,532

    Re: clicking activeX combobox disables worksheet

    This is not default behavior.
    The city names are populated when the workbook is loaded.
    How are you doing this? Do you have macros in this file? If so please attach the file (see yellow banner at the top of the page) or at a minimum paste the code from the worksheet module into a post (use code tags when posting code).

    How are you using the value in the combobox once an item is selected? Is the combobox linked to a cell, or are you using macros to act on the value?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-23-2021
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: clicking activeX combobox disables worksheet

    Thank you very much. The bug is in the worksheet "initialize" sub.

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

    Re: clicking activeX combobox disables worksheet

    No file is attached.

+ 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] ActiveX Combobox in worksheet when populating the list based on another Combobox get error
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2020, 10:54 AM
  2. Replies: 0
    Last Post: 10-26-2015, 04:25 PM
  3. On ActiveX ComboBox Change, switch focus to the active worksheet
    By ericbartha in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-29-2015, 10:54 AM
  4. ActiveX combobox datalist dependant on previous combobox selections
    By Mrs Poodle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2014, 07:07 AM
  5. [SOLVED] fill listbox (ActiveX) based combobox (ActiveX)
    By elsg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2014, 11:25 AM
  6. [SOLVED] WorkSheet ActiveX Combobox entry problem
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 06:58 PM
  7. Copy and Paste to Worksheet using Combobox (ActiveX)
    By okriskao in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-23-2009, 09:23 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