+ Reply to Thread
Results 1 to 4 of 4

Run Time Error 380?

Hybrid View

Macro1 Run Time Error 380? 07-16-2010, 07:41 AM
romperstomper Re: Run Time Error 380? 07-16-2010, 08:11 AM
Macro1 Re: Run Time Error 380? 07-16-2010, 11:15 AM
romperstomper Re: Run Time Error 380? 07-16-2010, 11:30 AM
  1. #1
    Registered User
    Join Date
    09-29-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    77

    Run Time Error 380?

    Hi,

    I have a template with a hidden sheet in it that stores a data dump from a SQL database, once the hidden sheet is populated with the data I have a simple mapping macro that brings the data through into the template.

    I have been populating various combo boxes but this particular one seems to be causing me the 380 error.

    Here is the code:
    Sheets("Template").CB_1.Value = Sheets("SQLData").Range("D68").Value & " - " & Sheets("SQLData").Range("E68").Value
    Any advice would be gratefully received.

    Many Thanks

    Macro1

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,980

    Re: Run Time Error 380?

    Does that combo have its Matchrequired property set to true?
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    09-29-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    77

    Re: Run Time Error 380?

    Thanks for responding, it's MatchRequired field is set to False. However I think it may be becuase the ListFillRange is populated.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,980

    Re: Run Time Error 380?

    That shouldn't be an issue.

+ 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