Remove Listbox item based on Textbox value

sharky12345

Well-known Member
Joined
Aug 5, 2010
Messages
3,311
Office Version
  1. 2016
Platform
  1. Windows
I'm populating a Textbox on a Userform based on a Listbox selection like this;

Code:
TextStaff.Value = ListBox1.Value

What I'd like to do now is remove the TextStaff value and have tried this but it doesn't work;

Code:
ListBox1.RemoveItem (TextStaff.Value)

Can someone show me how please?
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,823
Office Version
  1. 2013
Platform
  1. Windows
Here is how you remove items from a listbox.
This script removes the first value in the list.

Code:
Private Sub CommandButton5_Click()
ListBox1.RemoveItem (0)
End Sub
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,823
Office Version
  1. 2013
Platform
  1. Windows
To remove a particular value from a listbox use this:
Code:
Private Sub CommandButton5_Click()
For i = ListBox1.ListCount - 1 To 0 Step -1
  If ListBox1.List(i) = "Bob" Then
    ListBox1.RemoveItem (i)
  End If
Next
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,986
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top