<div>
I assume you want to edit and delete items on the Mamf sheet. Which columns on that sheet do you want to be able to edit?
</div>


<div>
Hi Martin,<br />
<br />
I want to able to edit columns C, D &amp;&nbsp;E on the Absences sheet. I would like to be able to delete individual records on the same sheet/
</div>


<div>
Just to clarify the delete bit, I would delete an entire row
</div>


<div>
OK, here's the delete code. Add a button to frmAbsences named cmdDelete and add this code. I'll be back in a few minutes with the edit code.<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-41783185-1"><span>Private Sub cmdDelete_Click()</span>
<span></span>
<span>    Dim lngLastRow As Long</span>
<span>    Dim lngRow As Long</span>
<span>    </span>
<span>    lngLastRow = Range(&quot;B1048576&quot;).End(xlUp).Row</span>
<span>    </span>
<span>    If cmbStaffName = &quot;&quot; Then</span>
<span>        MsgBox &quot;Please select a Staff Name to be deleted&quot;</span>
<span>        Exit Sub</span>
<span>    End If</span>
<span>    </span>
<span>    If vbYes = MsgBox(&quot;Are you sure you want to delete staff member &quot; &amp; cmbStaffName.Text &amp; &quot;?&quot;, vbYesNo) Then</span>
<span>        For lngRow = 4 To lngLastRow</span>
<span>            If Cells(lngRow, &quot;B&quot;) = cmbStaffName Then</span>
<span>                Cells(lngRow, &quot;B&quot;).EntireRow.Delete</span>
<span>            End If</span>
<span>        Next</span>
<span>    End If</span>
<span>    </span>
<span>End Sub</span>
</code></pre>
</div>


<div>
Hi Martin,<br />
<br />
The delete code is great thank you, however it deletes any random record with that staff name. There are several records for some staff names, I would like to be able to choose which record to delete.<br />
I have put a list box on the userform, &nbsp;could I choose which record from the list box? Or scroll through the records in the form to choose the one to delete?
</div>


<div>
OK, I thought you meant that you wanted to delete, say, row 12 from the Mamf sheet. Where do the records reside that you want to delete?
</div>


<div>
The records are on the absences worksheet. There is a table on there called absences which the frmabsences adds records to.
</div>


<div>
OK, so let me double-check. You want to select an entry in Listbox1 on frmAbsence and then either delete that entry from both the list and the Absences sheet or edit that Absences entry on the sheet. Correct?
</div>


<div>
One more question. You say you want column &quot;C&quot; to be editable. Are there rules to what it can be changed to?
</div>


<div>
Hi Martin,<br />
<br />
Column C is a combobox of Names selected from a Staff List Table - &nbsp;StaffList[Name] It should be a name in that list.<br />
<br />
Columns D &amp;&nbsp;E are dates, I use the frmabsences to enter the dates using a text box and the cdate vba<br />
<br />
I hope this all makes sense
</div>


<div>
OK, cooking dinner. Will try to finish this later tonight.
</div>


<div>
Take a look at my DataBaseForm available free here. It has been downloaded 1000s of times and has many features for working with Excel Databases.<br />
<br />
<a href="http://excel-it.com/excel_databaseform.html" rel="ugc">Free DataBaseForm</a><br />
<br />
Take a look and post back if you want help adapting it.
</div>


<div>
Here's a workbook that allows you to edit and delete entries from the Absences sheet. There is a problem however and that is that deleting records causes problems with your existing formulas.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w37/1115131/28967563.xlsm" target="_blank" class="file-inline" title="Edit and Delete (74 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>28967563.xlsm</a>
</div>


28967563.xlsm

<div>
Hi Martin,<br />
<br />
Thank you for all the work you've put into this. It is exactly what I'm looking for. When I edit records it doesn't appear to change the right record.<br />
<br />
There is an entry for example 5 rows down called Ann Green, I've tried changing the end date and it changes a different record leaving Ann Green record unchanged.<br />
<br />
I have a look through the code but I cant really establish what is causing this.
</div>


<div>
I'll be back in a couple of hours and I'll look at it then.
</div>


<div>
Thanks Martin,<br />
<br />
That is absolutely perfect. Thank you so much for all your the time and quick responses :-)
</div>


<div>
Thank you Martin, that has solved all of the problems and the form is working perfectly - Thank you again.
</div>


<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
<br />
Marty - Microsoft MVP 2009 to 2016<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange MVE 2015<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
</div>


<div>
<div class="content wysiwyg-content">
I have a table of absences which is populated through a userform, I would like to be able to add command buttons or toggles to the userform to be able to search the records and edit or delete them. I have attached the file, the form I am working on is called frmabsences which adds records to absence table.<br />
<br />
I am new to vb coding. any help appreciated. All details in the attached spreadsheet are fictitious for the purpose of developing the spreadsheet<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w36/1115070/TestMAMF2.xlsm" target="_blank" class="file-inline" title="The spreadsheet table my form relates to is called absences on the absences worksheet (66 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>TestMAMF2.xlsm</a>
</div>
</div>


The spreadsheet table my form relates to is called absences on the absences worksheet

TestMAMF2.xlsm

I have a table of absences which is populated through a userform, I would like to be able to add command buttons or toggles to the userform to be able to search the records and edit or delete them. I have attached the file, the form I am working on is called frmabsences which adds records to absence table.

I am new to vb coding. any help appreciated. All details in the attached spreadsheet are fictitious for the purpose of developing the spreadsheet

Excel userform vba code to edit and delete

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.