+ Reply to Thread
Results 1 to 6 of 6

Mac generating Runtime Error 380 when loading Range into Combobox

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,327

    Mac generating Runtime Error 380 when loading Range into Combobox

    This Code extract runs perfectly on my Windows, but End User has Mac. and it is generating a Run Time Error 380 at the line populating the "Lead" Combobox with a range of names labelled "LEAD".

    Please Login or Register  to view this content.
    All suggestions received gratefully
    Last edited by Ochimus; 05-13-2015 at 04:47 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac generating Runtime Error 380 when loading Range into Combobox

    Hello Ochimus,

    The Windows error 380 is "Invalid property value". Is this the same as on the Mac?

    Is the Mac user's workbook identical to the Windows version?

    Is the worksheet protected?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,327

    Re: Mac generating Runtime Error 380 when loading Range into Combobox

    Leith,

    Many thanks for responding.

    I have attached the file RunTIme Error.xlsm in question.

    It is what I provided to the End User, and as far as I am aware they have not changed anything, so both should be identical.

    The worksheets and file are not protected.

    As for the meaning of the Error message, I have never used a Mac, but I thought the message was created by Excel rather than the Operating System? Suggesting it would be the same on both.

    Ochimus

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac generating Runtime Error 380 when loading Range into Combobox

    Hello Ochimus,

    This problem is known to exist in some older Mac software. There is no RowSource property for ActiveX ListBox and ComboBox controls.

    To workaround the problem, you will need to load the ListBox or ComboBox directly from the named range.

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,327

    Re: Mac generating Runtime Error 380 when loading Range into Combobox

    Leith,

    Thanks for producing the explanation and solution,

    I had to wait for the User to confirm everything, and they are in Oz, so have only just got back to me saying everything now works smoothly.

    OChimus

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac generating Runtime Error 380 when loading Range into Combobox

    Hello Ochimus,

    You're welcome. Thanks for updating me on your progress. Glad to know your problem has been solved.

+ 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. Runtime error '1004': Paste special method of range class error.
    By Daryl Zer0 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2014, 01:44 AM
  2. Dependent Combobox code generating error
    By wendie1970 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2013, 12:31 PM
  3. [SOLVED] VBA Error: Runtime Error 1004: AutoFilter method of Range class failed
    By jl22stac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2013, 07:27 PM
  4. Cascading ComboBox Runtime Error
    By baisty182 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2010, 11:28 AM
  5. Runtime error 1004 while loading Add-In
    By PVBERG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2009, 04:22 PM

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