Help- find Startdate - Enddate in userform, and search in all columns

[rikmik]

Hi all. I am new here and this is my first post. I am new in excel vba and i am asking your help.

I have a file that has a searchform. I want help in 2 items.

In sheet "Production" i have data in columns (A-J).
the first column is a date and i want to make an option to chuse Startdate and Enddate of search in the form.
for example i have in the sheet dates from 01/01/2014 until 08/02/2014. and i want to chuse Startdate and Enddate between them.

The other one is the search of words in the textbox. now it is only on column (A) and i want it to be on all the used columns.
but when i change in the code to all the columns (A-J) it is showing me in the listbox only data from the cell to the end and not from column (A) to the end.

Thanks in advance

The code is here.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(Because you are new to the forum, I have added them for you today. Please read all Forum Rules and comply in the future.)

[rikmik]

Thanks. i will learn