show automatically rows of created data between two dates

I created a sample Form with data in the DATA sheet.

How can I write a code that displays automatically (without press Enter or etc), the rows of existing data in DATA sheet whose date of birth is between two dates entering in the TextBox From and To?

It does not matter if this form is in the Form sheet in Excel or in a UserForm1 (Alt + F11).

file attached.

Also asked in
https://www.mrexcel.com/board/thread...dates.1215092/

.
Hello.
I show you a way to do it:

Please Login or Register  to view this content.

No selection based on dates !

Form macro on orange button activates your UserForm - code in UserForm module.

See what I attached.

Error msg:

Could not load some objects because they are not available on this machine.

Double click textboxes to show calendar - if manually entering dates they need to be 10 characters long (dd/mm/yyyy) to trigger search after second textbox entry.
Date pickers look 'pretty' but I have always found them a 'faff' to use.

Excellent,

1- Is it possible to add a delete button to each row of resulted record in ListBox, which will delete the corresponding line from the DATA sheet of excel?

2- Is it possible to edit each row of resulted record in ListBox, so that by editing it and hitting a save button for that row, the corresponding record in the DATA sheet is also changed?

Some like this pic

give us a workbook file to use - pictures do not work.

Originally Posted by niksirat2030

Error msg:

Could not load some objects because they are not available on this machine.

.
Let's switch from Data Picker then. And it is used like this:

- Double click to display the data picker and
- Double click to select a date.

As far as I am aware there is no way to edit the listbox directly - it is purely a selection device - the method I have used for countless years is as per the attached file.
the form covers the norms of data input/output (ADD NEW / DELETE / UPDATE / SEARCH / VIEW)
to add a new row first 'CLEAR' then add data and press 'ADD' to transfer to sheet - to DELETE or UPDATE select in listbox and either edit data and hit UPDATE or just hit DELETE to remove from sheet.
to load UserForm click small green button (upper left cell)

@beyond Excel

I want to set header of list box equals to header of my table in DATA sheet, I use this code but returns error:

Please Login or Register  to view this content.

Try replacing:

Please Login or Register  to view this content.

For this other:

Please Login or Register  to view this content.

The idea is that:
a) Or use RowSource,
b) Or you use List

It doesn't work using both methods simultaneously.

Great, Is it possible to increase or decrease the width of the columns in the listbox in the Form when program runs by user?