autofilter and vba

[John Smith]

Hi,

I have a problem with excel2003.
UserForm has a textbox which is used to enter a date.
Autofilter is used to show data between two different dates.
It works(partly) as works the autofilter part of the macro(partly).
Partly means that autofilter part works when entering a date to the cell
by hand, but not when used through textbox.
Somehow the textbox is doing something with the data (in this case a
date). After entering the date through textbox You even can't autofilter
it by hand.

Does anyone know what happens to data when it's entered through textbox.
eg. Worksheets(3).Range("A2").Value = txtDate.Value

TIA,
tomi

 

[Bob Phillips]

Tomi,

Try casting the date

Worksheets(3).Range("A2").Value = CDate(txtDate.Value)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[John Smith]

Bob,

Thanks That worked, althou I had to add CLng to Your suggestion (as
follows):

Worksheets(3).Range("A2").Value = CLng(CDate(txtDate.Value))
(as i prefer dates like dd.mm.yyyy

BRGDS,
Tomi

 

[Bob Phillips]

I gave you a hint, you solved. Double satisfaction <vbg>

Bob