Excel 2007 Macro Help (Buttons)

[.paul.]

you could add a button, which would open the parts site with the search criteria being the activecell value:

Private Sub CommandButton1_Click()
    Dim partsSiteURL As String
    partsSiteURL = "http://h20141.www2.hp.com/hpparts/SearchCriteria="
    ActiveWorkbook.FollowHyperlink Address:=partsSiteURL & ActiveCell.Value
End Sub

then you'd just need a column with the barcode part numbers.