VBA Assistance

[JDL]

Excel 2003 - Vista
Hello,
I am extremely new to vb coding in excel and wondered if someone could tell me what needs to be done.
I have a sheet with the following data in.
A - Date
B - Company
C - Project
I also have managed to create a user form that allows the user to enter in a date. I need to get the form to go down my list and pull out any data where the dates match.
I dont have a clue where to start and have looked at other threads posted but if i'm honest i think i was in the little boys room when god was handing out intelligence!
Could someone offer this fool some assistance.
Many Thanks

 

[onlyadrafter]

Hello and welcome.

Why have a user form? why not just use another sheet (tab), and have the date entered in one cell, then use VLOOKUP, or INDEX/MATCH?

 

[jim may]

Or use an Auto-Filter on your data, selecting from the Date Header your desired date.
Done

 

[JDL]

The reason that i wanted to do it this way is so that once the items were listed for the user to see then they could hit a "remove" button which would then remove the relevant lines for them.
Ideally i dont want the users to have 'access' to the sheets themselves but allow them to get information via the forms.

 

[JDL]

i was just interested in getting the list. no problems if this cant be done, thanks for the assistance.

 

[Weaver]

Where would you want this retrieved data to appear?

 

[JDL]

Ideally i would like the user form to have the boxes for entering the selection criteria, to hit a display button which would show the list within the user form. The user can then select the relevant 'lines' and hit Delete.

I'm not sure if this is even possible but as i know naff all about excel i thought i'd ask. any assistance is sincerely appreciated.