Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
deleting userform or VBA modules by makro | Excel Programming | |||
Check if Userform exsists before deleting via VB | Excel Programming |