I see that you have a macro that does an Advanced Filter every time you
select cell C3 (I think I'd just run it from a button but to each his own).
Now what does this have to do with a combo box? I see no code related to a
combo box. The combo box is from the Forms toolbar or the Control Toolbox
toolbar?

--
Jim
"Brussels1200" wrote in message
...
| Hello All,
| Sorry for my bad english, i'm french.
| I have found on Debra's Website a nice tutorial which contains a macro to
| automate a filter which is in another sheet.
| It's working perfectly, the problem I have is that instead of using the
| combo box in the same sheet I would like to use the combo box which is
| located in another sheet but in the same workbook.
| I'm not good at VBA scripting, here is the code:
|
| Private Sub Worksheet_SelectionChange(ByVal Target As Range)
| If Target.Row = 3 And Target.Column = 3 Then
| 'calculate criteria cell in case calculation mode is manual
|
| Worksheets("euList2").Range("h2").Calculate
| Worksheets("euList2").Range("eutable2") _
| .AdvancedFilter Action:=xlFilterCopy, _
| CriteriaRange:=Sheets("euList2").Range("h1:h2"), _
| CopyToRange:=Range("A6:F6"), Unique:=False
| End If
| End Sub
|
| how can I change the link to the combo box i'm using if the combo box is
in
| Cell H10 in my sheet name "Summary"??
|
| Thanks a lot