VBA double click in a cell to navigate to another tab and auto-filter

[a_bahchevanov]

Hi All,

I'm totally new to VBA scrips and macros and was wondering if you could help me out with a solution for the below:

I have a spreadsheet with several tabs/sheets. In one of the tabs, I have a column which I would like to make it interactive - i.e. if the user double-clicks it, to navigate to another tab and apply a filter to a column.

Attaching the spreadsheet.

The column where the user should double click is in Tab "Detailed(employee) View" - column L(work Pattern) and the target sheet is "Work Pattern" and auto-apply filter against column A ( row 4 ).

Version is Microsoft 365 MSO (16.0.13801.20240) 32-bit

Thanks in advance!

Regards,
Aleks

[simoncm]

Two steps to this
1 - put the data in "Work Pattern" into a table, this makes it easier to refer to in the vba (to do this, unmerge cell m3:m4 and select the range "A4:M8" and click the "Table" button in the "Insert" tab of the ribbon, make sure "My table has headers" is checked. Once done, click anywhere in the table, goto the "Table Design" tab in the ribbon and name the table "WorkPattern").
2 - open VBA editor, in the project explorer double click on "Sheet4 ("Detailed (employee view)", in the window paste the following code - each line in the code has a comment telling you what it does.

Please Login or Register  to view this content.