DELETING DATA FROM USERFORM
 

Hi,

I have a program that uses a userform to display data, on this form i
select a row on a listbox on the form and i use code to remove that
row.

if there any good code that will remove a row from a listbox, i have
the code for selecting the required row, and do i have to unload the
form so i can see the changes to the listbox within the userform
John

DELETING DATA FROM USERFORM
 

Try some code like the following:

With Me.ListBox1
.RemoveItem .ListIndex
End With



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


wrote in message
ups.com...
Hi,

I have a program that uses a userform to display data, on this
form i
select a row on a listbox on the form and i use code to remove
that
row.

if there any good code that will remove a row from a listbox,
i have
the code for selecting the required row, and do i have to
unload the
form so i can see the changes to the listbox within the
userform
John