I have an Excel spreadsheet that is created from an Ado recordset in Access. The spreadsheet contains 1 row per mailing address. The idea is to have customer service folks scan this list of their clients for people they DO NOT want to send to, and eliminate them (delete the row) by clicking on some sort of control.

In other words, I need a delete control of some sort on every row with data that deletes itself and its row.

Any ideas would be appreciated! Thanks in advance!

Brian Klakring

Howdy!

Sounds like a UserForm might be the way to go. Here is an example/discussion about how to do that:

UserForm example to add/delete

When ive done this kind of thing before it becomes notroiously difficult to control,
my advice would be to have a column that the user can double click in to delete the said row using the
event

Dave

Thanks for your help! I've gotten past that issue satisfactorily.

I ended up adding a field to the ADO recordset that populates the worksheet with a column of "DELETE". Then I added the following code to the worksheet...

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Delete row if user double-clicks on "Delete"

If Target.Value = "Delete" Then
Target.EntireRow.Delete
End If

End Sub

Simple and effective.

Again, thank you both for your help!

Brian