How to convert this VBA code to UDF code?

[shafiey]

Option Explicit
Sub FilterBasedOnCellValueAnotherSheet()
Dim category As Range
With Worksheets("Sheet8")
Set category = .Range("C2")
End With
With Worksheets("Sheet7")
With .Range("B4:G13")
.AutoFilter Field:=2, Criteria1:=category, VisibleDropDown:=True
End With
End With
End Sub

 

[Herakles]

What would you like this function to return or do that is different to your code?

 

[shafiey]

What would you like this function to return or do that is different to your code?

I want to automatically filter another column in another sheet by entering a value in one cell without running the macro.

 

[Herakles]

I want to automatically filter another column in another sheet by entering a value in one cell without running the macro.

If you want to filter a range automatically without running a macro then you can use the FILTER function that will automatically chnge the rows filtered when the
value in cell C2 changes.

' For example:

=FILTER(B5:G13,C5:C13=Sheet8!C2,"")

 

[shafiey]

If you want to filter a range automatically without running a macro then you can use the FILTER function that will automatically chnge the rows filtered when the
value in cell C2 changes.

' For example:

=FILTER(B5:G13,C5:C13=Sheet8!C2,"")

C5:C13 has the following formula:

=IFERROR(MID(N2,1,4)*1,"")

How can I apply the filter for the above formula?

 

[Herakles]

C5:C13 has the following formula:



How can I apply the filter for the above formula?

What does N2 contain?

 

[shafiey]

What does N2 contain?

A 4-digit number, for example 2022

 

[Herakles]

A 4-digit number, for example 2022

So why are you using the MID function on N2? Why not just refer to N2 in the range C5:C13.

 

[shafiey]

So why are you using the MID function on N2? Why not just refer to N2 in the range C5:C13.

Sorry.
In N2, there is a number with a general format and a pattern similar to 1352/10/24.
When the formula is implemented on it, only its 4-digit number remains, for example 1352.

 

[shafiey]

So why are you using the MID function on N2? Why not just refer to N2 in the range C5:C13.