'先在sheet1中插入一个按钮Private Sub CommandButton1_Click()Dim s As String, q As Strings = Sheets(1).Cells(ActiveCell.Row, ActiveCell.Column) 'sheet1选择的单元格的值If s = "" Then
MsgBox "没有选择查询项目"
Exit SubEnd Ifq = ""For i = 1 To Sheets(2).UsedRange.Rows.Count
'从第一行一直到最后一个使用的行
For j = 1 To Sheets(2).UsedRange.