+ Reply to Thread
Results 1 to 4 of 4

Error '438' in Excel 2016 with combo box

  1. #1
    Forum Contributor
    Join Date
    10-06-2015
    Location
    Leeds, England
    MS-Off Ver
    365 Version 2302 Build 16.0.16130.20942
    Posts
    130

    Error '438' in Excel 2016 with combo box

    Our company is moving from Office 2013 to 2016 and as part of this process we are testing our existing Excel based programs to ensure they all work in the new Office. I've found with one particular program there is a combo box on one sheet that breaks the code in Workbook Open when trying to clear the combobox. The error '438' is received.
    We've checked everything we can think of, the sheet is referenced before the combo box "Sheets("Sheet1").ComboBox1.clear" , the correct references are enabled, the sheet is unprotected. All the other comboboxes in the workbook are fine, just this one falls over.

    Any ideas? Unfortunately I can't post the workbook here due to sensitive information.

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Error '438' in Excel 2016 with combo box

    how are you populating that combobox,At least you can Post a sample of your original workbook with a few records (desensitized). your code etc.
    Teach me Excel VBA

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Error '438' in Excel 2016 with combo box

    What happens if you refer to the sheet the combobox is on directly using the codename?

    For example.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    10-06-2015
    Location
    Leeds, England
    MS-Off Ver
    365 Version 2302 Build 16.0.16130.20942
    Posts
    130

    Re: Error '438' in Excel 2016 with combo box

    I would have tried this but a colleague has decided to remove the combobox and recreate in the new version of Office and it seems to have fixed it. Not sure why it didn't work in the first place :/

+ 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: 6
    Last Post: 03-31-2021, 04:24 PM
  2. Replies: 4
    Last Post: 03-02-2018, 10:49 AM
  3. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. VBA Open FilePath from FTP location - Excel 2016 error
    By mwc360 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2017, 01:34 PM
  5. Replies: 4
    Last Post: 09-07-2016, 04:52 AM
  6. Excel 2016 Error in Formula or its a bug?
    By pattyyy in forum Excel General
    Replies: 16
    Last Post: 07-18-2016, 12:01 PM
  7. Excel Mac 2016 VBA error, need help
    By BlakeMile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2015, 03: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