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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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