Manipulating range from listbox

Hi,
I'm not sure if it's possible but I'm trying.. it may be a bit tautological.
I've got a range (say a1:g10) which is being displayed by a listbox (which contains 7 columns) placed in userform.
Within this listbox I can easily "mark" with the mouse a specific row (say a2:g2), question: can I delete that marked row? in other words is it possible to "affect" the original "database" (a1:g10) from the listbox?

Of course - just make sure that you specify the sheet in the rowsource string, like
'Sheet1'!A1:G10
and assign code like this to a commandbutton on your userform.

Please Login or Register  to view this content.

Thanks Bernie. It works smoothly!. For better understanding: why to use negative STEP?
Also, in this line - no need to specify which RANGE are we talking about?

Range(Me.ListBox1.RowSource).Rows(i + 1).Delete

I used negative step because I was not sure if your listbox was mulit-select - deleting row 2 will change row 3 to row 2, and then the indexing is messed up. Easier to just go backwards...

And we are specifying the range:
Range(Me.ListBox1.RowSource).Rows(i + 1)

Me.ListBox1.RowSource is a range address - with or without the sheetname - add these lines and you will see

Msgbox Me.ListBox1.RowSource
Msgbox Range(Me.ListBox1.RowSource).Address
Msgbox Range(Me.ListBox1.RowSource).Rows(i + 1).Address

Thanks alot for the clarifications.