Saqib Husain
asked on
Simple phonebook application starting to get complicated.
I have a phonebook application developed in this question.
https://www.experts-exchange.com/questions/28636136/Extending-a-simple-phonebook-application-in-excel-to-include-additional-columns.html
This application is limited to 4 columns and has been extended from a 2-column application. To increase its functionality, I would like to improve on it such that the fields are defined from the column labels in row 1.
So basically the routine would look at row 1 and setup fields according to the cell entries in row 1. This would enable to have option to play with the field names as well as the number of fields.
Another minor change is to have the phone numbers treated as text so that leading zeros are not trimmed.
https://www.experts-exchange.com/questions/28636136/Extending-a-simple-phonebook-application-in-excel-to-include-additional-columns.html
This application is limited to 4 columns and has been extended from a 2-column application. To increase its functionality, I would like to improve on it such that the fields are defined from the column labels in row 1.
So basically the routine would look at row 1 and setup fields according to the cell entries in row 1. This would enable to have option to play with the field names as well as the number of fields.
Another minor change is to have the phone numbers treated as text so that leading zeros are not trimmed.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 500 points for Robert Schutt's comment #a40691493
Assisted answer: 0 points for Saqib Husain, Syed's comment #a40691580
for the following reason:
Thanks a lot.
Accepted answer: 500 points for Robert Schutt's comment #a40691493
Assisted answer: 0 points for Saqib Husain, Syed's comment #a40691580
for the following reason:
Thanks a lot.
ASKER
Sure thing!
It's up to you of course but I would suggest adding the first comment as an assisted solution as well since the basis was there and the column D text setting was also suggested there.
The problem with the empty column I had forgotten to mention but when it happened to me I simply saved the file (which seems to delete unused space unless there is some content left in those columns) and the problem was solved.
I'm not sure yet when I'll have time to look at your next question, probably later tonight.
It's up to you of course but I would suggest adding the first comment as an assisted solution as well since the basis was there and the column D text setting was also suggested there.
The problem with the empty column I had forgotten to mention but when it happened to me I simply saved the file (which seems to delete unused space unless there is some content left in those columns) and the problem was solved.
I'm not sure yet when I'll have time to look at your next question, probably later tonight.
ASKER
To follow the expert's suggestion
ASKER
Thanks
ASKER
I think that the labels and the textboxes should be "added" at initialize. The form height should be adjusted accordingly.