VBA: Auto Filter listbox based on Textbox Value

[Xlacs]

Hi Everyone,

I'm kinda new to this VBA and come across a problem with my project.
I'm seeking for some expert who can help me with this one.

So, i have a userform with listbox and a texbox that have a defualt value using Environ. Extracting the username.
In my excel sheet. I have a pivot listed employee name is with textbox and second column is their productivity numbers.
Whenever that user activate the userform, that textbox autofill it's value by their name.

What I wanted to achieved is whenever the textbox value match my pivot my list box will only filter the list with match the textbox.

I have attached Screenshot of my sheet.

Listbox1.Rowsource = Daily!A1:B5000

This just extract the whole data. I wanted to show just the data of the employee of the name in the textbox.

Thank you guys!

 

[DanteAmor]

There is a possibility that you change your data to something like the example below.
In this way it will be easier for you to work with your data, to filter, organize, group, take a table or a pivot table, for subtotals, formulas, even for macros, in short for everything. The way you have your data you will have difficulties for everything.

Dante Amor
	A	B	C
1	Employee	Date	Prod
2	Emp1	01-oct	20
3	Emp1	02-oct	21
4	Emp1	03-oct	22
5	Emp1	04-oct	23
6	Emp1	05-oct	24
7	Emp1	06-oct	25
8	Emp1	07-oct	26
9	Emp1	08-oct	27
10	Emp1	09-oct	28
11	Emp2	01-oct	23
12	Emp2	02-oct	24
13	Emp2	03-oct	25
14	Emp2	04-oct	26
15	Emp2	05-oct	27
16	Emp2	06-oct	28
17	Emp2	07-oct	29
18	Emp2	08-oct	30
19	Emp2	09-oct	31
20	Emp3	01-oct	26
21	Emp3	02-oct	27
22	Emp3	03-oct	28
23	Emp3	04-oct	29
24	Emp3	05-oct	30
25	Emp3	06-oct	31
26	Emp3	07-oct	32
27	Emp3	08-oct	33
28	Emp3	09-oct	34
Hoja5

 

[Xlacs]

There is a possibility that you change your data to something like the example below.
In this way it will be easier for you to work with your data, to filter, organize, group, take a table or a pivot table, for subtotals, formulas, even for macros, in short for everything. The way you have your data you will have difficulties for everything.

Dante Amor
	A	B	C
1	Employee	Date	Prod
2	Emp1	01-oct	20
3	Emp1	02-oct	21
4	Emp1	03-oct	22
5	Emp1	04-oct	23
6	Emp1	05-oct	24
7	Emp1	06-oct	25
8	Emp1	07-oct	26
9	Emp1	08-oct	27
10	Emp1	09-oct	28
11	Emp2	01-oct	23
12	Emp2	02-oct	24
13	Emp2	03-oct	25
14	Emp2	04-oct	26
15	Emp2	05-oct	27
16	Emp2	06-oct	28
17	Emp2	07-oct	29
18	Emp2	08-oct	30
19	Emp2	09-oct	31
20	Emp3	01-oct	26
21	Emp3	02-oct	27
22	Emp3	03-oct	28
23	Emp3	04-oct	29
24	Emp3	05-oct	30
25	Emp3	06-oct	31
26	Emp3	07-oct	32
27	Emp3	08-oct	33
28	Emp3	09-oct	34
Hoja5

Hi!

Thank you for the suggestion.. That make sense.. However, I'm still not able to filter my listbox based on my textbox value..