ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,251
- Office Version
- 2007
- Platform
- Windows
Hi,
I am using the code below.
Some info for you.
Table is called Table 2
Headers are in row 3
Row 4 is hidden.
My table is the range A to K
Values at present are A5 to K21 but will grow etc as time goes on.
The code shown loads the customers from the table & allows me to select & deletes a customer.
I make some notes outside of the table BUT when i open the userform these notes are also shown.
How can the code be edited so that only the values in the table are shown thus my notes are not loaded into the userform
See my example photo
Thanks
I am using the code below.
Some info for you.
Table is called Table 2
Headers are in row 3
Row 4 is hidden.
My table is the range A to K
Values at present are A5 to K21 but will grow etc as time goes on.
The code shown loads the customers from the table & allows me to select & deletes a customer.
I make some notes outside of the table BUT when i open the userform these notes are also shown.
How can the code be edited so that only the values in the table are shown thus my notes are not loaded into the userform
See my example photo
Thanks
Rich (BB code):
Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Dim i As Long
Dim lr As Long
Dim sh As Worksheet
Set sh = Sheets("GRASS")
With ListBox1
sh.Rows(.ListIndex + 5).Delete
lr = sh.Range("B" & Rows.Count).End(xlUp).Row
If lr > 4 Then .RowSource = sh.Name & "!A5:B" & lr
For i = 0 To .ListCount - 1
If .Selected(i) Then .Selected(i) = False
Next
End With
Unload RemoveCustomer
Range("A5").Select
End Sub