message input box returns lines/rows based on the input

Hello,

I am a newbie here who is kinda helpless. Been working on this table for 10 days now and I couldnt find a work around the data i need to get.
i have a message input box where users will provide their names, and perhaps addional information, then once information is in, id like the worksheet to return the rows/lines filtered based on the inputs of the users.

so far, i have only arrived to this first code and i dont know who to get to the next level. your help will be very much appreciated. thanks in advance.

Sub GetUserName()

Dim strName As String

strName = InputBox(Prompt:="You name please.", _
Title:="ENTER YOUR NAME", Default:="Your Name here")

If strName = "Your Name here" Or _
strName = vbNullString Then
Exit Sub
Else
Select Case strName
Case "Damon"
'Do Damons stuff
Case "Vince"
'Do Vinces stuff
Case "Singh"
'Do Singhs stuff
Case Else
'Do other stuff
End Select
End If

End Sub

I do not know where/what your data looks like but this might give you a start:

Please Login or Register  to view this content.

Thank you Coretroy. I should probably attach here the table. This is in fact extracted from a huge database program and have removed the other columns I dont need.

What I was looking for is when:
A message Input box such as "Enter Name"
Followed by Input box " Cat"

Will return the excel sheet filtered as per the data requested by user.

Appreciate your help. Ta.

See Attached.

Hi again. Is it possible that these filter buttons come out as a pop up message once you open excel?

The House icon on the ribbon will reset the filter if needed.

When opening the Wkb the prompt will be displayed.

Hello coreytroy. thank you again. your code works really well until i tried to apply it on mine. i suck in vba programming and im hoping to receive some more help from experts like you.

I got this table extracted from our database and what i was trying to do is to once i open this file, the message input will come out requiring users to choose their name, the category they want and the status. the code works till searching ones name, but the 2 other list boxes becomes empty and i cant choose the item i want. would really appreciate if you can put some touch to this one please....thanks again in advance.

See attached.

Hi coreytroy! I dont know how you did it, but you are a genius! Thank you sooo much. It works perfectly!

Will also see how to add a scroll bar on the owner list box as it looks like we'll have more than 20 names.

Originally Posted by excelandclark

Will also see how to add a scroll bar on the owner list box as it looks like we'll have more than 20 names.

A scroll bar will appear automatically if the list exceeds the visible listbox.

Glad to help.

Note: Please mark the thread as solved.

Hello coretroy. my table is almost finished thanks to you.

perhaps you could help me how to add a click button to reset the filters on the left side or somewhere in this table (such as inserting a column on the left of coulmn A). thanks

Thanks coreytroy. is there a way also to make the listbox categories in alphabetical order? like the names of the owner in listbox 1 and categories in listbox2? thanks a bunch.

Hi Coretroy.. is there a chance for this to be converted to 2003?