haziqFARHAN
New Member
- Joined
- Nov 24, 2021
- Messages
- 4
- Office Version
- 2019
- Platform
- Windows
Hi, I am stuck for few days regarding below problem. Hope someone can help me.
As mention in title, I want to delete entire row at worksheet based on selection at multicolumn listbox by a button.
Let's say the name of listbox is ListBox1 and have 8 column inside.
Data is populate from worksheet named "Raw Data" by using RowSource method (ListBox1.RowSource="RawDataRange").
I already made the range of data using Name Manager. Let's say, RawDataRange are consist range from A2 to H10000 .
Now, if I select data from ListBox1 and click a delete button, the data from sheet "Raw Data" will deleted also in the ListBox1.
The result might be have few but i want to delete the data exactly same with I selected since the column have 8. So that only all 8 column is same will delete.
Please someone. Thanks in advance.
As mention in title, I want to delete entire row at worksheet based on selection at multicolumn listbox by a button.
Let's say the name of listbox is ListBox1 and have 8 column inside.
Data is populate from worksheet named "Raw Data" by using RowSource method (ListBox1.RowSource="RawDataRange").
I already made the range of data using Name Manager. Let's say, RawDataRange are consist range from A2 to H10000 .
Now, if I select data from ListBox1 and click a delete button, the data from sheet "Raw Data" will deleted also in the ListBox1.
The result might be have few but i want to delete the data exactly same with I selected since the column have 8. So that only all 8 column is same will delete.
Please someone. Thanks in advance.