Remove items from a listbox
I haven't actually got any code to do the command at the moment as I couldn't
work out how to do it. Sorry if i'm not too clear, I just need the code to do
the following:
When an item is selected in a listbox and the button (that i'm applying the
code to) is pressed, it removes the item from the list box. After doing that
the code then needs to remove the corresponding value from the spreadsheet
(where I am getting my source for the listbox).
For example, I have a list set out in excel in the A column. This list is
the source for my list box. When you select a value from the list box and
press btn X, it removes the value from the list box and from the spreadsheet.
Thanks Andy
|