title: Using Excel ComboBox to pull information from one file to another
body: <p>I am trying to copy information from an excel database file to an excel display file. I have figured out how to copy that information in and I have different macros depending on the different information I am looking at. These seem to be working by themselves. </p>
  
  <p>However I also want to include a dropdown field that will then allow the user to select which set of data they would like to see (basically which customer). My code is below, I am new to the site so if any formatting is incorrect please let me know so I can improve it :)</p>
  
  <pre><code>    Private Sub ComboBox1_Click()
  
      Select Case ComboBox1.Value
        Case "Acme"
          'Acme Macro
          ' Pulls Acme Customer Information from Database for each Segment
          Application.CutCopyMode = False
          Windows("Product_List_Template.xlsx").Activate
          Sheets("Segment1").Range("C1:C278").Copy
          Windows("Tool V0A.xlsm").Activate
          Sheets("Segment1").Range("J1:J278").Paste
          Application.CutCopyMode = False
          Windows("Product_List_Template.xlsx").Activate
          Sheets("Segment2").Range("C1:C278").Copy
          Windows("Tool V0A.xlsm").Activate
          Sheets("Segment2").Range("J1:J278").Paste
          Application.CutCopyMode = False
          Sheets("Dashboard").Select
          Application.CutCopyMode = False
          Calculate
        Case "Ball"
          ' Ball Macro
          ' Pulls Ball Customer Information from Database for each Segment
          Windows("Product_List_Template.xlsx").Activate
          Sheets("Segment1").Select
          Range("D1:D278").Select
          Selection.Copy
          Windows("Tool V0A.xlsm").Activate
          Sheets("Segment1").Select
          Range("J1:J278").Select
          ActiveSheet.Paste
          Windows("Product_List_Template.xlsx").Activate
          Sheets("Segment2").Select
          Range("D1:D278").Select
          Application.CutCopyMode = False
          Selection.Copy
          Windows("Tool V0A.xlsm").Activate
          Sheets("Segment2").Select
          Range("J1:J278").Select
          ActiveSheet.Paste
          Sheets("Dashboard").Select
          Application.CutCopyMode = False
          Calculate
        Case Else
          Exit Sub
      End Select
      End Sub
  </code></pre>
  
  <p>So the code is selecting the correct Case and then when it starts into the designated macro, I am having a "Run-time error '1004': Select method of Range class failed" popping up. When I go to debug the code it has "Range("D1:D278").Select" highlighted as when it failed. I have tried copying columns, I have tried copying smaller ranges, and nothing is working. All the cells in the range have information in them but for some reason it is just not working. I really appreciate anyone's help!</p>