Home > Excel Tutorial > Simple And Useful Userform – Address Book

Simple And Useful Userform – Address Book

        I created the userform that  to run in all version of Excel.

With this 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 deleted.

Excel address book with userform

Download Example File

 

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: