jetimmins
01-03-2012, 09:52 AM
Heyya,
I have a column of data which is the source for my drop down list, i.e
A
-
Apples
Oranges
Limes
Old Man
Grapefruit
I want to be able to delete the source data that I have selected from my drop down list with a vba button, so e.g
- Limes selected from drop down
- Button Pressed
- The row with Limes on in the list source data is deleted, in this case it's row 3
Any ideas on the macro for the button that would do this?
Thanks for any help <3
I have a column of data which is the source for my drop down list, i.e
A
-
Apples
Oranges
Limes
Old Man
Grapefruit
I want to be able to delete the source data that I have selected from my drop down list with a vba button, so e.g
- Limes selected from drop down
- Button Pressed
- The row with Limes on in the list source data is deleted, in this case it's row 3
Any ideas on the macro for the button that would do this?
Thanks for any help <3