Hi folks...
wonder if someone can help me out with a query I have on some excel VBA code.
I am creating a search interface for a set of data and for the life of me, cannot get an autofilter function to work on a list of dates (dates of birth to be precised... not that that really makes any difference!)
The data on my dataset is in DD/MM/YYYY format and I have a userform with a TextBox (TextBox3) which will require for the user to input the date of birth they are searching for.
However, for some reason, even if a date is entered in the TextBox that I KNOW appears in my dataset, the autofilter function is returning no records (when it should be returning 5).
Anyone got any ideas?
I have the following code in the VBA :
I'm not sure why that code doesn't work as I am entering (for example) 22/04/1950 into TextBox3, know this date appears in column C 5 times but yet it returns no results!
And its doing my pan in!!!
Any help is appreciated guys!
Cheers,
Graeme
wonder if someone can help me out with a query I have on some excel VBA code.
I am creating a search interface for a set of data and for the life of me, cannot get an autofilter function to work on a list of dates (dates of birth to be precised... not that that really makes any difference!)
The data on my dataset is in DD/MM/YYYY format and I have a userform with a TextBox (TextBox3) which will require for the user to input the date of birth they are searching for.
However, for some reason, even if a date is entered in the TextBox that I KNOW appears in my dataset, the autofilter function is returning no records (when it should be returning 5).
Anyone got any ideas?

I have the following code in the VBA :
Code:
...
Range("C5:C5000").Select
Selection.AutoFilter Field:=1, Criteria1:=TextBox3.Value, VisibleDropDown:=False
...
I'm not sure why that code doesn't work as I am entering (for example) 22/04/1950 into TextBox3, know this date appears in column C 5 times but yet it returns no results!
And its doing my pan in!!!

Any help is appreciated guys!
Cheers,
Graeme