justdream
02-26-2011, 12:27 PM
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??
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??