Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove item from list box
Hi,
how can I remove the item "PMname" from the listbox in following code? Dim farx As Range UserForm1.ListBox1.RowSource = "Roster!paizapm" Dim Title, Default Dim PMname As Variant Title = "Please enter the value you want to find?" PMname = InputBox(Title, Default, 100, 100) Set farx = Cells.Find(What:=PMname) If farx Is Nothing Then MsgBox "There is no item called as " & PMname Else '*****HERE HOW CAN I REMOVE THE ""PMname""***** End If -- Regards, Baha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove an item from the recently used files list | Excel Discussion (Misc queries) | |||
I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
Remove an item from a list | Excel Discussion (Misc queries) | |||
Cannot remove item from collection | Excel Programming | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |