I am relatively new to VBA and was wondering if it were possible to have a Userform that, when opened, allows the user to type a Vendor's Company, Employee Name, Email, and Phone Number. This will then send it to a worksheet with a growing list of vendor information in a table.
On another sheet I have a Userform that has two Comboboxes; one that has a list of company names and the other with the corresponding employee(s). When you pick a Company from the first Combobox the second Combobox can ONLY display contacts from that company. After the employee is chosen, a form on the spreadsheet is filled out with the employee's Company, Name, Email, etc.
Overall I am just looking for a way to easily add contacts to a spreadsheet without having to type all the information in every time or having to sift through 300 vendor names to find the employees of a specific company. I am hoping to be able to end up with one table with company and employee information and on the other spreadsheet a Userform that has two dropdowns with the second only being relative to the first one.