+ Reply to Thread
Results 1 to 9 of 9

Combo, list and text boxes no longer selectable

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Combo, list and text boxes no longer selectable

    When I move my cursor over my combo, list and text boxes the cursor stays as the plus sign. I am not able to select options in the boxes or place my cursor in them to type. It is like they have been disabled. How do I fix this? Thank you.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Combo, list and text boxes no longer selectable

    You symptoms seem to indicate that you are in 'Design Mode'. When you exit 'Design Mode', the controls should behave as you expect.

    For more information about 'Design Mode', see: http://www.addintools.com/documents/...sign-mode.html

    Lewis

  3. #3
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Combo, list and text boxes no longer selectable

    It isn't in design mode. I have put it in design mode, turned it off and this didn't have any effect on it.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Combo, list and text boxes no longer selectable

    If this file is saved to a "cloud service" and you are opening from the "cloud" by clicking on the file and you have preview in Windows Explorer turned on, it is possible to get the behaviour that you experiencing. If this is the case, turn off the preview.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Combo, list and text boxes no longer selectable

    If it just started happening check this
    http://excelmatters.com/2014/12/10/o...ivex-controls/
    Cheers
    Andy
    www.andypope.info

  6. #6
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Combo, list and text boxes no longer selectable

    Andy's reply reminded me of a fix for a similar problem that has worked for me in the past.
    a. Make a copy of the offending sheet
    b. Delete the original offending Sheet
    c. Rename the copy back to the name of the original

    Lewis

  7. #7
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Combo, list and text boxes no longer selectable

    This isn't in any cloud type service. I tried all suggestions. I did have an issue a few days ago where I had some named ranges linked to the combo boxes. I moved the lists to a different sheet which caused VBA errors to show up. I updated the new sheet name in the VBA. However my text boxes are not linked to any lists and shouldn't have been affected by that, but they are not selectable.

    Restarting the computer didn't work either.

  8. #8
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Combo, list and text boxes no longer selectable

    And now when I click on them, the picture tools tab shows up. Shouldn't it be the drawing tools tab? I think deleting it all and starting over would be simpler.

  9. #9
    Registered User
    Join Date
    02-10-2014
    Location
    West Babylon, NY
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Combo, list and text boxes no longer selectable

    It might be caused by Windows Update -Security Update for Microsoft Office(KB2553154) - 32 Bit Edition
    All my ActiveX Controls on my Worksheets did not function.
    I uninstalled this update and the Controls worked properly.
    Hope this helps.

+ 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] Help with code for userform text boxes, combo boxes and excel
    By innerise in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2014, 09:07 AM
  2. populating list boxes and combo boxes in a user form.
    By ahceinaej in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2014, 11:54 AM
  3. Selected data from combo boxes to text boxes
    By soulun in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-22-2013, 06:48 AM
  4. Selecting subsets using combo boxes or list boxes
    By CLamar in forum Excel General
    Replies: 0
    Last Post: 06-01-2006, 02:45 PM
  5. Filtered list for Combo Box ListFillRange - Nested Combo Boxes
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2006, 08:20 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