hyperlink with filter function

**deadfish** · 11-15-2009, 12:04 AM

Hi,

I have more than 10 textboxes. I would like to filter the data on another worksheet base on which textbox the user clicks on. I have tried the Worksheet_FollowHyperlink event, but it does not work with the textbox hyperlink.

Please help. Thx!

**Leith Ross** · 11-15-2009, 12:10 AM

Hello deadfish,

It would help to see your workbook. Can you post a copy?

**deadfish** · 11-15-2009, 12:22 AM

Attached pls find the sample file.

What I want to do is when user click on the "1" textbox, it then jumps to Sheet2, filter column A with the value "1". When user clicks on "14" textbox, the Sheet2 should be filtered by the value "14".

Please advice. Thx.

**Leith Ross** · 11-15-2009, 01:15 AM

Hello deadfish,

Instead of a Hyperlink, I added a macro to each Text Box. The macro takes the entry and filters column "A" on "Sheet2" using that value. Here is the macro that has been added to the attached workbook.

Sub FilterData()

  Dim TBname As String
  Dim Wks As Worksheet
  Dim X As String
  
    TBname = Application.Caller
    X = ActiveSheet.Shapes(TBname).TextFrame.Characters.Text
    
    Set Wks = Worksheets("Sheet2")
    Wks.Cells.AutoFilter Field:=1, Criteria1:=X
    
End Sub

**deadfish** · 11-15-2009, 11:02 PM

it works! thx!!

**noeldickinson** · 01-20-2010, 10:56 AM

Hi,

A slightly different requirement - What I want to do is when a user clicks on the "text1", "text2", "text3" etc cells in column A on Sheet1, it hyperlinks to Sheet2, filters column A on sheet 2 to show all matching text rows.

Both sheet1 and sheet2 cell columns are using a data validation list - Source: =text_names

text1
text2
text3
text4
etc

Fairly new to this so some basic assistance would be good.

Thanks

**foxywfu** · 08-26-2010, 02:54 PM

Any way to do this for cells instead of text boxes?

**vasilisa** · 12-02-2010, 11:21 AM

Hi. I have a similar problem as well. I want to select a cell in a table (Sheet1) that contains a string, than via hyperlink want to go to Sheet2 where I have a second table and I want that table already filtered by that string.
I will be very grateful if anyone can help.
Thanks.

**jmehta78** · 07-04-2011, 11:36 AM

Can someone help - as above need to create a hyperlink which when selected goes to a specific sheet in my wookbook and filters to the correct details - can anyone show me a simple way this can be acheived?

**Mike Chester** · 03-16-2012, 03:47 AM

Hi,

I would also like to know if there is a way where when you click a cell with a value in sheet 1, then it will automatically filter using the value you click in sheet 1 a column in Sheet 2?

The column in Sheet 2 is of course will contain a value that is same on the cell that you click in Sheet 1, and this value is the one that will be filtered out.

Thanks.