User Form: Search Column & Match Value between 2 Dates

[ahmed elsery]

hello guys
i need some help
since im new to excel and vba
i was working on a little project to help me in my job a little
so i wanted to make a search by date userform

i inserted textbox1 and textbox2 and found a calendar i can use to select dates easly and show the result in the list box
but i cann't find the formula to search match the value between the 2 dates
search col = C

working on database sheet
listbox1 doesn't show the result with headers and all information
so anyone can help me with that ?
i would be v.thankfull


Userform (1).xlsm

[torachan]

help us to help you - see big yellow banner - how to upload your workbook - far easier to give answers when in relative context.

[Marc L]

Hello,

use CDate VBA function to convert your text to an Excel valid date
then you can use the Range.Find methog (like any Excel user finding manually, easy with the Macro Recorder help)
or the MATCH worksheet function in order to find out the relative row ...

[ahmed elsery]

help us to help you - see big yellow banner - how to upload your workbook - far easier to give answers when in relative context.

Thats it u can check
Thanks

[AliGW]

I have closed your duplicate thread - continue HERE, please.

[ahmed elsery]

okay thanks

[AliGW]

You also need to make your thread titles less generic going forward. Yours is incredibly vague and tells us nothing of what you are wanting help with in a useful way. Thanks.

[ahmed elsery]

am sorry but can u suggest title ? :/

[AliGW]

Use something from your post that actually tells us specifically what you are having an issue with - what do you want resolving?

For example:

User Form: Search Column & Match Value between 2 Dates

[ahmed elsery]

ya that's it exactly ..... thanks so much <3

[AliGW]

No worries. Please follow this pattern in future. Note: I used YOUR words!!! So you could have don it yourself.

[ahmed elsery]

is there anyone able to help me with that situation ?

[AliGW]

Please be patient. You may bump your thread only after 24 hours have elapsed. Today is a Sunday, a non-working day in many parts of the world and not a busy day on the forum. The help you get here comes for free: please don't press for it. Thanks.