ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
I dont normaly use Listbox but trying it today.
I can load listbox fine but i get a compile error when i select an item to the n delete a record.
The code below in red is my issue but not sure why & also assume once that is sorted the rest is ok
I dont normaly use Listbox but trying it today.
I can load listbox fine but i get a compile error when i select an item to the n delete a record.
The code below in red is my issue but not sure why & also assume once that is sorted the rest is ok
Rich (BB code):
Private Sub ListBox1_Click()
For i = Range "GRASS!A5:B" & Range("B" & Rows.Count).End(xlUp).Row
If listDisplay.Selected(i) Then
Rows(i).Delete
End If
End Sub