Excel Userform - Address Book
I updated the userform that I did previously to run it in all version of Excel.
With this VBA userform ;
☑️ Data can be added
☑️ Data can be deleted
☑️ Data can be edited
☑️ Data can be searched on the sheet
☑️ Listbox can be filled and emptied with button.
☑️ Listbox can be scrolled with the spin button.
Id numbers are generated automatically when new record is added to the worksheet
and when record is removed.
The listbox is empty when the userform is opened.
The entered value in the searching box can be searched on the worksheet. Listbox are filled with the
found results .
The listbox column widths is automatically adjusted
according to the widths of the sheet's column with Vba codes.
Read more ...