VBA code to find and delete cell contents based on userform combobox selections

[anfdrew]

I have 3 Worksheets that are exactly the same in setup to record dates for different events(For this example you can call them sheet1, sheet2 and sheet3). I have a userform that has two comboboxs and a textbox. The first combobox (combobox1) allows the user to select from a list of names that is in column “a” on each work sheet. Combobox 2 allows the user to select the worksheet. The text box allows the user to enter a date.

What I need is a VBA code that when a user clicks on a delete button it selects the worksheet from combobox 2, finds the row which the name selected in combobox1 is on and finds the date in the textbox within that row and deletes that date only.

I do not have any idea how to set this code up. Please help

Thanks

[AlphaFrog]

Please Login or Register  to view this content.

[anfdrew]

Thank you! this worked perfectly!