How to delete data from worksheet

[umayank]

Hi,

I have created a user form in VBA and that form searches for data from one worksheet depending on the data in Column 1 and displays it on the text boxes in the form. Attached is the excel sheet. If you click on the button 'Click here for asset return' it opens a VB form and then If you enter the employee name it searches the same in the Issue Worksheet and diaplayes the asset owned by the employee.

When ever I click on Update Return Master Button it creates an entry into the Returns worksheet. I want that when it is writing the entry into the Return worksheet it should delete the entry from Issue simultaneously.

Can you help me with this please.

Thanks
Mayank

[royUK]

The databaseform example has a delete function

http://www.excel-it.com/vba_examples.htm

[umayank]

Thanks for the help, but the code in this example is deleting from the same worksheet.. I need to delete the data from a different sheet.

[royUK]

Then amend the code to work with the sheet that you require