Extending a simple phonebook application in excel to include additional columns

Further to a simple application provided here

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27940206.html

I would like to add columns "Designation" and "Address" at columns 2 and 3 and shift the "Phone Number" column to 4 to the PhonebookEEv3 file and also add these fields to the userform.
LVL 43
Saqib Husain, SyedEngineerAsked:
Who is Participating?
 
Robert SchuttSoftware EngineerCommented:
Sure, no problem.
PhonebookEEv4.2.xls
0
 
Jeff DarlingDeveloper AnalystCommented:
0
 
Saqib Husain, SyedEngineerAuthor Commented:
Hi, thanks, but only the name box is working. The others are not.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Robert SchuttSoftware EngineerCommented:
Not sure what happened to Jeff, but try this version.

Note that Jeff's version seems to have some improvements over my code but not knowing what his plan was exactly I started with the previous version.
PhonebookEEv4.1.xls
0
 
Saqib Husain, SyedEngineerAuthor Commented:
Looks good. I would, however like to have a small change.

The "Add" button should be active even when the fields are empty.
0
 
Saqib Husain, SyedEngineerAuthor Commented:
Perfect, thanks
0
 
Saqib Husain, SyedEngineerAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.