asked on Extending a simple phonebook application in excel to include additional columns
Further to a simple application provided here
https://www.experts-exchange.com/questions/27940206/Simple-phonebook-macro.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.
https://www.experts-exchange.com/questions/27940206/Simple-phonebook-macro.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.
Microsoft Excel
Last Comment
Saqib Husain
ASKER
Hi, thanks, but only the name box is working. The others are not.
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
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
ASKER
Looks good. I would, however like to have a small change.
The "Add" button should be active even when the fields are empty.
The "Add" button should be active even when the fields are empty.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect, thanks
ASKER
This is starting to get complicated.
https://www.experts-exchange.com/questions/28644454/Simple-phonebook-application-starting-to-get-complicated.html
https://www.experts-exchange.com/questions/28644454/Simple-phonebook-application-starting-to-get-complicated.html
PhonebookEEv4.xls