Thread: Delete function in a userform

I have a userform but I'm lacking one function to it which I've never done before, delete.

It's a registry with a few columns. I have a edit function which works like this:


Private Sub cmbName_Change()
Dim lngNum As Long
With cmbName
lngNum = .List(.ListIndex, 0)
End With
Call ReadFromDB(lngNum + 1)
End Sub


The user get's a dropdown list, chooses one and the data input previously registered comes up and available for edit. What I want to do is have a simular function, expect to delete the enter row and the entire addition to the registry.

1) At the moment I have two buttons in the sheet, Add and Edit, would it be possible to add a new button called 'Delete' just assigned to finding additions and deleting them?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

That's not code tags I'm afraid. The code should be prefixed with
[ code] your code [/code]

Note no spaces in the square brackets