Hey all please help, what i want to do is be able to select a value in the listbox, press remove and it removes that value from the sheet and shifts the cells up so there is no blank spaces. i have attached a sample sheet. thanks
Hey all please help, what i want to do is be able to select a value in the listbox, press remove and it removes that value from the sheet and shifts the cells up so there is no blank spaces. i have attached a sample sheet. thanks
Try this...
The .ListIndex is the Item number of the selected item in the listbox. The Item number starts at Zero for the first Item. Your RowSource for a Listbox starts at row 2. Add two to the listindex number and that is the row number of the selected item.Please Login or Register to view this content.
Last edited by AlphaFrog; 06-05-2017 at 08:58 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Ah ok I see thanks allot that did the trick.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks