Excel 2007 : Finding all the matching dates in vba excel 2007

[Mrjfnlnd]

Hi everyone!I am very new in this forum and I am looking forward for your help.

I have this database file and in Sheet RawData, Column D, I have all the measured date of the samples. I made a search userform having a listbox that contain all the unique dates from that Column D. Once I click the listbox,the value is put in Range(StartSheet!AZ3).

Now the problem is that, I want to hide the entire row from RawData, row 5 to 3000 and find all the matching dates corresponding to Range(StartSheet!AZ3). Then It will unhide the entirerow of all the matching dates.

Its my first time to use Dates in the search function and Im having a headache with it. Hope you can please help me as soon as possible!This is a very important and urgent project.

Thanks,
Mrjfnlnd

[DonkeyOte]

It might help if you post a sample file, however, have you considered applying AutoFilter on RawData using the date specified as criteria against Column D ?

[Mrjfnlnd]

Hi,

Thanks for your response.

Would you please give some code on how to autofilter based in cell value. Lets say based on the value in the Range(StartSheet!AZ3). How to autofilter the RawData column D with the given value?

[Mrjfnlnd]

Thanks for the time and reply!I really appreciate it,It took awhile and now I already solved the problem. I may post a new thread later. So see you again in here

[Mrjfnlnd]

Hello again,

I1. would like to ask,how to avoid duplicate entry using three textbox in a userform.

TextBox1 = Name 'Column A
TextBox2 = Date 'Column B
TextBox3 = Time 'Column C

It can be that there is duplicate Name or Date and Time but it shouldnt be that the combination of the three textbox are same.

2. And if its a duplicate, it must go to the column A where the value is located and load it in separate form to check if it needed to edit the values.

A fast help is greatly appreciated.