Sebastiandiaz
Member
Hello, I work for a guest services company. We are required to get many information of extension number, phone numbers etc to people who call us. I created an Excel UserForm to get the information faster. My WorkBook is called "Agenda", it has several Sheets for the days of the week. Every Sheet has a CommandButton to call my UserForm called "Agenda".
This UserForm has two parts, 1. for searching information and 2. for adding new information. I made a ListBox where you can see all the information that is in Dynamic Table in the Sheet "Agenda". The TextBox1 has a code that I made and it allows me to find the information everytime I type on it, so it filters all that appears in the ListBox1.
What I can not do is adding New Data to the "Agenda Sheet", and could it be possible to do that and once it is added "Agenda Sheet", to be organized in alphabetical order?
I created 3 TextBoxes next to "Type to Search" TextBox. I would love those 3 TextBoxes(Name, Telephone and Additional Information) to display the information of the contact when I search from that TextBox .
I would really appreciate your help on this.
I am sending images and the original file to see if you can help me.
Thank you very much
Sincerly yours,
Sebastian.
This UserForm has two parts, 1. for searching information and 2. for adding new information. I made a ListBox where you can see all the information that is in Dynamic Table in the Sheet "Agenda". The TextBox1 has a code that I made and it allows me to find the information everytime I type on it, so it filters all that appears in the ListBox1.
What I can not do is adding New Data to the "Agenda Sheet", and could it be possible to do that and once it is added "Agenda Sheet", to be organized in alphabetical order?
I created 3 TextBoxes next to "Type to Search" TextBox. I would love those 3 TextBoxes(Name, Telephone and Additional Information) to display the information of the contact when I search from that TextBox .
I would really appreciate your help on this.
I am sending images and the original file to see if you can help me.
Thank you very much
Sincerly yours,
Sebastian.