Input box filter

[justdream]

Dears,

I'm using input box filter to allow users entering their required data to be selected and filtered
as shown

Area = InputBox("Enter your required Area")
Range("A1").AutoFilter Field:=1, Criteria1:=Area

but I faced special case: some users want to select two variable (example: filter for Asia and USA)

how could I let users select multiple inputs
using above input box filter??

 

[VoG]

Perhaps

area = InputBox("Enter your required Area Separated by Comma")
x = Split(area, ",")
If UBound(x) = 0 Then
    Range("A1").AutoFilter Field:=1, Criteria1:=area
Else
    Range("A1").AutoFilter Field:=1, Criteria1:=x(0), Criteria2:=x(1)
End If

 

[Smitty]

Or use a ListBox.

 

[justdream]

Or use a ListBox.

Thanks Dear, could you please describe how to use it..
Sorry, I'm newbie in VBA codes

 

[Smitty]

There's a good overview here.