Delete/add/update list in spreadsheet via User form.

This is not exactly what you want,
but maybe you want to have a look.

Please Login or Register  to view this content.

In the userform the controls are :
1. ComboBox ---> ComboBox1 ---> for name list
2. TextBox ---> tb1 ---> a textbox to update or add name
3. TextBox ---> tb2 ---> a textbox to update or add phone number
4. CommandButton ---> CLEAR ---> is used to add name and phone number
5. CommandButton ---> DELETE ---> to delete the selected name in the ComboBox1
6. CommandButton ---> DONE ---> to close the userform

To update/correction :
- select the name first in the ComboBox1
- in tb1 delete the existing text, type the correct name then hit enter on the keyboard (if you want to update the name)
- in tb2 delete the existing text, type the correct number then hit enter on the keyboard (if you want to update the phone number)

To add new name and it's phone number
- click CLEAR button to deselect any name in the ComboBox1
(this will let the code know that when the user type a name in tb1 then hit enter ---> then this is adding a new data)
- type the new name in tb1 FIRST then hit enter
the code will add a new name to the last blank row of column A of the active sheet,
and call the PopulateComboBox sub to update the ComboBox1 list name.
- then type it's phone number in tb2 then hit enter
Please remember the bold text. So, don't fill the new phone number first in tb2.

To delete the existing data:
- select the name first in the ComboBox1
- click DELETE button
the code will delete the entire row which consist the selected name value in column A
then call the PopulateComboBox sub to update the ComboBox1 list name.

First Condition :
EXCEL_2021-09-18_14-36-32.png

Update existing data:
2021-09-18_14-37-21.gif

Add new name + phone number:
2021-09-18_14-38-20.gif

Delete existing data:
2021-09-18_14-38-48.gif

Please ignore the post if this isn't what you mean.

There will probably be duplicate names in your Name column so I would urge you to add an extra column with a unique numeric value or ID-number or another combination.

You can then refer to that unique value in your code to manipulate data to prevent you from updating or deleting the wrong name.

I ripped one of my userforms down to similar to the options u wanted. maybe you can find it useful

You most likely have Option Explicit on top of your module. This forces you to declare all variables you use in your code.

Take a look at the yellow banner on top of the page on how to attach your workbook.

Take a trip through the code of the attached it has all the basics of 'Add'/'Update'/'Delete'
To 'Add' first 'Clear' the form for new entry - fill in details then 'Add' - the rest should be intuitive.
The code is 'longhand' and readable.
Any queries post back on this site.

Try this for starters.

All the code you need is in the userform module. This is how userform code is setup.

PS: Attachment is invalid.

I'll attach again the error. I think it's not finding the form so it does not know what to do next even though I'm running the form myself.

Edit: I already try deleting "Option Explicit" in my code and it does not work anyways.

Edit 2: I'll try to attach my grader form too. I'm so sorry to bother you but I will appreciate if you can help me one more time.

Captura.PNGCaptura.PNG

it would be easier to help if your file was not password protected.

An error like this arises when something goes wrong on openeing the userform (Userfom_Initialize)

Since you try to open the form without any data present on the worksheet the Initialize-event goes into Debug.

To test put some data in the worksheet like your previous example file and try again.