Filtering data with textbox value (date)

**torppo** · 09-02-2014, 02:07 AM

Hi all,

On my userform(FrmKivaDiaari) I have two textboxes for user to write date values if he/she wants to filter data only between those dates. In my example below I am only using start date as example but for some reason not able to make this work. Is there something wrong with Format or why vba does not understand how to filter with this value.
Lets assume that I have data for every single day for last month. Then, user wants only to show those data lines which have been created on August 18th or after. User writes date to textbox "TxtAlkuPvm" and hits search button. But for some reason every single line of data is filtered out.

Please Login or Register  to view this content.

Thank you for your help!
Ville

**humdingaling** · 09-02-2014, 03:10 AM

what is the output of your text field?

are you missing .value?
FrmKivaDiaari.TxtAlkuPvm.value

**torppo** · 09-02-2014, 04:29 AM

Output? How can I tell the output of a textbox?

**torppo** · 09-02-2014, 06:05 AM

Anyone??? This should be fairly easy to solve.

**torppo** · 09-02-2014, 06:52 AM

Hi again.

If I use (as below) = instead of >= code works perfectly. Just can't understand why it isn't working!?

Please Login or Register  to view this content.

**humdingaling** · 09-02-2014, 09:30 PM

Originally Posted by torppo

Output? How can I tell the output of a textbox?

use debug and watch

as i have tested your code on sample data

Please Login or Register  to view this content.

ps fin date uses . while in Australia we use - or / so the format is the same
the code works fine as intend so the only thing that is a variable is the output of the form.textbox of which i have no way to debug

**torppo** · 09-03-2014, 01:13 AM

Hi humdingaling,

I did some further testing and stopped macro after that code line was excecuted. Then I went to see active spreadsheet and found out that there is active filtering in 7th column with right criteria (FrmKivaDiaari.TxtAlkuPvm). BUT, funny thing was that all data has been filtered away. THEN I went to see what kind of filter (I selected: column filter->Date filter->Custom filter) there was for that column and I could see that there is just the filter on place AND after I clicked OK-button data was filtered correctly.
I just can't understand what's going on with this...

**torppo** · 09-04-2014, 01:14 AM

Anyone with a solution for this??

**humdingaling** · 09-04-2014, 02:17 AM

as far as i can tell the code should be working correctly

very hard to see what you are you seeing with the actual file and i'm guessing for reason you cannot share the file

**torppo** · 09-04-2014, 02:41 AM

Hi Hum,

Unfortunately I cannot share file here but if you would give me your email address I could send you that.

Ville

**oeldere** · 09-04-2014, 03:10 AM

@troppo

general suggestion:

make a fake excel file, which containes your problem, without confidential information.

please also add the desired (expected) result.

then the forummembers can test the given solutions, and also post it on the forum (the excel file, with the given solution).

**torppo** · 09-18-2014, 07:29 AM

Hi guys,

I have attached a sample file. Maybe this time problem will be solved.

Write for example day 15.8.2014 in to textbox at Userform and see what happens at Excel file. Filter is on place but for some reason none of the values appear at the spreadsheet.

Cheers,
Ville

**watersev** · 09-18-2014, 08:39 AM

hi Villie,

Userform code, slightly amended:

Please Login or Register  to view this content.

Autofilter code:

Please Login or Register  to view this content.

**torppo** · 09-19-2014, 01:37 AM

Woo hoo watersev! Works like a charm!! Thank you extremely much!

Cheers,
Ville

**torppo** · 09-19-2014, 01:40 AM

Oh,

One more question just popped to my mind. What about if I have two textboxes and I want to filter between those days?

Ville

**watersev** · 09-19-2014, 03:55 AM

autofilter accepts two criteria with operator And/Or

**torppo** · 09-19-2014, 06:44 AM

Thank you for your reply watersev. Problem solved!

Filtering data with textbox value (date)

LinkBack

Thread Tools

Rate This Thread

Display

Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Re: Filtering data with textbox value (date)

Thread Information

Users Browsing this Thread

Similar Threads

Filtering data based on start and end date

If textbox value = hidden row number then next row - Data Filtering on Userform

listbox filtering via textbox

Filtering data dependent on the date

Help filtering date related data

Bookmarks

Bookmarks

Posting Permissions