Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS2007 - deleting filtered data, deletes non-visible data too Nita Excel Discussion (Misc queries) 1 December 9th 08 03:42 PM
Deleting cell data without deleting formula Tom Hall Excel Discussion (Misc queries) 4 October 29th 06 04:07 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com[_2_] Excel Programming 3 May 6th 05 05:44 PM
deleting userform or VBA modules by makro pat \(belgium\) Excel Programming 2 March 1st 05 03:08 PM
Check if Userform exsists before deleting via VB Rich[_15_] Excel Programming 1 September 19th 03 05:10 AM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"