I use a Combobox Control with a list of named ranges in the dropdown-list to access the relevant range within an active workbook.
 However, when the namedranges are outside the sheet where the ComboBox is embedded, for example in accessing a named range in sheet3, an error message is displayed:
     "Run-time error '1004'
     Method 'Range' of object 'Worksheet' failed"

  Is there any guru out there to correct/add codes to the following to enable the named ranges in other sheets to be open and selected?
   Here is the code :

 Private Sub ComboBox1_Click()
Range(ComboBox1.Value).Activate

End Sub

Private Sub ComboBox1_Change()

    Application.Goto Reference:=ComboBox1.Value

End Sub

Thanks , Jason.
The codes could not work very well initially, when I return to the Sheet where the Combobox resides.
  However, by changing the "change" event to "Click" for the Combobox, it works wonderfully!

 Private Sub Combobox1_Click()

  Application.Goto Reference:=Combobox1.value

 End Sub