+ Reply to Thread
Results 1 to 12 of 12

cannot click on combobox and cannot insert an object

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    cannot click on combobox and cannot insert an object

    Hi guys - has anyone come across this before ? All of a sudden I simply cannot click on a combobox drop down and niether can I create a new combobox and get the msg "Cannot Insert Object".

    EDIT -I have discovered that I cant insert any active x controls - and receive the Cannot insert object message

    I have sent the wb to some colleagues, and others have accessed it from its location and it works fine for them!

    Any ideas as to why I cant select the drop down?

    Many thanks
    Last edited by Blake 7; 12-10-2014 at 07:03 AM.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: cannot click on combobox and cannot insert an object

    For anyone ever experiencing this problem - I resolved it by deleting my temp files

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: cannot click on combobox and cannot insert an object

    I've just seen a similar problem posted on another forum, so it may be an issue with a recent Office update.
    Remember what the dormouse said
    Feed your head

  4. #4
    Registered User
    Join Date
    04-25-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: cannot click on combobox and cannot insert an object

    Experiencing the same problem. Nothing works this morning but was OK last night... My Combobox only works on excel 2014... This issue must be from an update of Microsoft, what should we do now ?

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: cannot click on combobox and cannot insert an object

    Close all your Office apps, search your computer for files with .exd extension (NOT .exe !!) and delete them. Then try again. Note you will need to include hidden and system files and folders in the search.

  6. #6
    Registered User
    Join Date
    12-10-2014
    Location
    Prague
    MS-Off Ver
    15
    Posts
    2

    Re: cannot click on combobox and cannot insert an object

    you have to delete AppData\Local\Temp\Excel8.0\MSForms.exd in your user directory

    it's http://support.microsoft.com/kb/2726958 that's causing this trouble

  7. #7
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: cannot click on combobox and cannot insert an object

    Hey Subaros - I simply did a disk cleanup and was sure to include the Temp files - it worked for me!

    Knowing Romperstomper, his suggestion is bound to work and is probably more efficient than mine!!

  8. #8
    Registered User
    Join Date
    12-10-2014
    Location
    FL
    MS-Off Ver
    Office 2010
    Posts
    1

    Re: cannot click on combobox and cannot insert an object

    I registered on the forum just to let everyone know that deleting *.EXD files fixed this issue!!! Now I can finally get some work done! THANK YOU!!

  9. #9
    Registered User
    Join Date
    02-16-2015
    Location
    Indore
    MS-Off Ver
    2007
    Posts
    2

    Thumbs down Re: cannot click on combobox and cannot insert an object

    I've used all the given solutions but doesn't works for me !!!

    Please help!!

  10. #10
    Registered User
    Join Date
    12-10-2014
    Location
    Prague
    MS-Off Ver
    15
    Posts
    2

    Re: cannot click on combobox and cannot insert an object

    try to install all the latest updates for Office

  11. #11
    Registered User
    Join Date
    02-16-2015
    Location
    Indore
    MS-Off Ver
    2007
    Posts
    2

    Angry Re: cannot click on combobox and cannot insert an object

    Nothing working.... !!!

  12. #12
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: cannot click on combobox and cannot insert an object

    shivesh,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

+ 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. Replies: 0
    Last Post: 06-19-2014, 02:09 PM
  2. [SOLVED] Open ComboBox using TAB instead of having to use mouse click
    By leopardhawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 01:42 PM
  3. Filter and insert in label as you click in combobox
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2013, 08:39 AM
  4. Combobox - Click row - Jump to sheet
    By mendesrr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2011, 06:32 AM
  5. Macro to click control object & add file as object
    By wayneknox in forum Excel General
    Replies: 0
    Last Post: 07-22-2009, 10:09 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