+ Reply to Thread
Results 1 to 3 of 3

Exiting Design Mode causes my ActiveX Listbox to stop working

  1. #1
    Registered User
    Join Date
    04-13-2018
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    6

    Question Exiting Design Mode causes my ActiveX Listbox to stop working

    Hi Everyone,

    I have an interesting issue that I really need some help with.

    I'm running Microsoft? Excel? for Microsoft 365 MSO (Version 2304 Build 16.0.16327.20200) 64-bit.

    I opened a new workbook, entered data in cells B2:B11 and named that range rManagers.
    I then added a activex listbox to the worksheet and set the following properties.
    ListFillRange = rManagers
    ListStyle = 1 - fmListStyleOption
    MultiSelect = 1 - fmMultiSelectMulti

    This gave me a listbox with 10 items and a checkbox for each item.
    Closed the workbook and reopened.
    Listbox works as expected. I can check 1 or more boxes in the list. So far so good. No problems.
    On Developer Tab, I clicked Design Mode to enter design mode, then clicked it again to exit design mode. No changes to the control.

    This is where it gets interesting.

    The listbox is no longer interactive. I click the checkboxes and nothing happens. When I select a cell outside of the listbox the checked list items are then highlighted.

    Closing and reopening the workbook clears the issue but as soon as I enter design mode and exit, it's back.

    I've not seen this behavior in earlier versions of Excel. I've attached the sample file.

    Any advice?

    Thanks in advance. I really appreciate you all.

    Terry
    Attached Files Attached Files

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

    Re: Exiting Design Mode causes my ActiveX Listbox to stop working

    I followed your steps and could not reproduce your problem. The issue may be with your (old) version of Excel, or possibly a corruption in your install.

    https://youtu.be/xT0WqWUxvpM
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,272

    Re: Exiting Design Mode causes my ActiveX Listbox to stop working

    Quote Originally Posted by phchcsg View Post
    I'm running Microsoft? Excel? for Microsoft 365 MSO (Version 2304 Build 16.0.16327.20200) 64-bit.
    Please update your profile to indicate your actual version of Excel. (Not sure what those ? are but I'm guessing you tried include the trademark symbol. No need for that unless you are Microsoft.)

+ 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. Toolbar Design Mode Off but Combo and button in design mode
    By TeacherWart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2022, 02:42 PM
  2. ActiveX controls getting more and more troublesome, can't click/open design mode
    By pharmacologist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2019, 02:07 AM
  3. Calendar DDMMYYYY Format working only in design Mode
    By exlove in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2019, 12:57 PM
  4. [SOLVED] Design Mode not working.
    By sickreto in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-28-2015, 05:25 PM
  5. Replies: 4
    Last Post: 06-06-2013, 10:21 AM
  6. Why is ActiveX invisible in Design mode
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2005, 06:06 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