PDA

View Full Version : Use a spinbutton to change items in listbox and update sheet that populates listbox



biggercrap
11-09-2012, 09:34 PM
Thanks Bob, that makes me feel a lot better! I'll have to get into the habit of using list. I spent a good three hours trying to figure it out this morning; time to move on.
Hi, I couldnt PM to you due to new posting < 10 counts.

With reference for the KB articles KB_id=963,

how do i change the
Private Sub CommandButton_Add_Click() and
Private Sub CommandButton_Remove_Click()

so that it only remove row of a single column
i.e column 'A' instead of the whole row?

p45cal
11-10-2012, 12:07 PM
you might try changing:
.Rows(iRow).Insert Shift:=xlDown
to:
.cells(iRow,"A").Insert Shift:=xlDown

and:
.Rows.EntireRow(i + 1).Delete
to:
.cells(i + 1,"A").Delete Shift:=xlUp

though it may not be the whole story…