[TABLE="width: 200"]
<tbody>[TR]
[TD]10-NOV-18[/TD]
[TD]AA[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DF[/TD]
[TD]aa[/TD]
[/TR]
[TR]
[TD]11-NOV-18[/TD]
[TD]BB[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DT[/TD]
[TD]bb[/TD]
[/TR]
[TR]
[TD]12-NOV-18[/TD]
[TD]CC[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DF[/TD]
[TD]cc[/TD]
[/TR]
[TR]
[TD]12-NOV-18[/TD]
[TD]DD[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DT[/TD]
[TD]dd[/TD]
[/TR]
</tbody>[/TABLE]
ListBox in Userform
[TABLE="width: 100"]
<tbody>[TR]
[TD]All[/TD]
[TD]DF[/TD]
[TD]DT[/TD]
[/TR]
</tbody>[/TABLE]
OptionButton in Userform too
Dear All Masters,
I create a Userform which has ListBox and OptionButton on the bottom of userform
1- I want to filter ListBox after it is populated by OptionButton to show only rows with data "DF" or "DT" on column 5
2- I want to show all data when I select OptionButton "All"
Pls kindly help me accordingly. Your help is very much appreciated. Thanks All Sir(s).
<tbody>[TR]
[TD]10-NOV-18[/TD]
[TD]AA[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DF[/TD]
[TD]aa[/TD]
[/TR]
[TR]
[TD]11-NOV-18[/TD]
[TD]BB[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DT[/TD]
[TD]bb[/TD]
[/TR]
[TR]
[TD]12-NOV-18[/TD]
[TD]CC[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DF[/TD]
[TD]cc[/TD]
[/TR]
[TR]
[TD]12-NOV-18[/TD]
[TD]DD[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]DT[/TD]
[TD]dd[/TD]
[/TR]
</tbody>[/TABLE]
ListBox in Userform
[TABLE="width: 100"]
<tbody>[TR]
[TD]All[/TD]
[TD]DF[/TD]
[TD]DT[/TD]
[/TR]
</tbody>[/TABLE]
OptionButton in Userform too
Dear All Masters,
I create a Userform which has ListBox and OptionButton on the bottom of userform
1- I want to filter ListBox after it is populated by OptionButton to show only rows with data "DF" or "DT" on column 5
2- I want to show all data when I select OptionButton "All"
Pls kindly help me accordingly. Your help is very much appreciated. Thanks All Sir(s).