+ Reply to Thread
Results 1 to 6 of 6

Excel Combobox stopped working

  1. #1
    Registered User
    Join Date
    04-26-2011
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Question Excel Combobox stopped working

    I have a excel spreadsheet which contains multiple userforms, This is hosted on my companies "Intranet" and as such when opened by the user it opens within Internet explorer.

    Currently we are still using Microsoft office 2003 within the workplace.

    The problem is that the company are (finally) upgrading from IE6 to IE8 and as a result of this the combo boxes which are a major component of my user form have stopped working.

    When opening the workbook using IE6 then it opens within the browser and works without any problems (Or rather only very minor issues which the end user can resolve) and the combo boxes within the user-forms actually work correctly as drop-down boxes (They are populated by referencing a named range on a hidden sheet within the workbook)

    However if a user who has got IE8 installed tries to use the form then the combo-boxes do not populate.

    Does anybody have any ideas as to how I can solve this issue as unfortunately our company IT section do not care as:
    We didn't design the form therefore its not our problem if it breaks


    Any help would be appreciated. If required I can send the workbook but would rather not post it therefore will email to people if required.
    Last edited by RHill; 04-27-2011 at 08:06 AM. Reason: Mark as solved

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Excel Combobox stopped working

    With what VBA-code do you populate the comboboxes ?

    Maybe posting that code will suffice to solve your problem.



  3. #3
    Registered User
    Join Date
    04-26-2011
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Excel Combobox stopped working

    Hi snb.

    In response to your question I do not use any VBA code to populate the comboboxes - I have a named range in one of the sheets of my workbook and I reference to this within the properties of the combox (Name of range in the "RowSource" option of the combobox properties.)

    Again this works fine both when opening up directly into excel or when using IE6 to open the hosted file it just IE8 that seems to have a problem with it.

    If it wasn't for the fact that I need to ensure that people are always using the latest version of the workbook then I would just tell them to save it to there machines and run it from there but this is not really a feasible solution as the workbook is updated on a regular basis.

    I have attached a sample file so you can see what I mean.
    Attached Files Attached Files
    Last edited by RHill; 04-26-2011 at 06:19 AM. Reason: added sample file

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Excel Combobox stopped working

    Does it make any difference in IE8 if the sheet 'hidden' isn't hidden ?

  5. #5
    Registered User
    Join Date
    04-26-2011
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Excel Combobox stopped working

    Quote Originally Posted by snb View Post
    Does it make any difference in IE8 if the sheet 'hidden' isn't hidden ?

    I tried this but it still doesn't change anything.

    I have had a couple more thoughts on this and will test them then post a update as to what I tried & also if it worked (or not)

    Thanks.

    Richard

  6. #6
    Registered User
    Join Date
    04-26-2011
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Excel Combobox stopped working

    Right here the solution I have come up with which seems to work:

    I insert this bit of code in the Userform code to be run when the form opens:

    Please Login or Register  to view this content.

    I have not worked out why the method I was using didn't work (especially as it works fine on another userform I have created)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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