Another option is to create dropdown lists of the dates on the worksheet
using data validation:

http://www.contextures.com/xlDataVal01.html

Create a dropdown for start date, and one for end date, then format
these dates the same as the dates in column C.

The user selects a start and end date from the dropdown lists, then
runs the AutoFilter macro:

'==================================
Selection.AutoFilter Field:=3, Criteria1:="=" & Range("K1").Value, _
Operator:=xlAnd, Criteria2:="<=" & Range("L1").Value
'==================================


Ron McCormick wrote:
I would like to write a procedure that would allow a user
to enter dates ie one greater than and the other less than
in a programmed autofilter procedure.

Essentially I would want the user to be able to insert
their own chosen dates in place of the dates that appear
in the undernoted code without them seeing the code.

Selection.AutoFilter Field:=3, Criteria1:="31/10/2002",
Operator:=xlAnd, Criteria2:="<=31/10/2003"

TIA
Ron


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html