I'm only now realizing how in over my head I am with this project I'm working on, bear with me through any faux-pas or misunderstandings, my lexicon is rather new yet.
The problem:
I've got an Excel file loaded up with data as a scheduling tool for the agency I work for. Its purpose is to send out an email, and make a new task item, for the employees of this company. Currently, it emails and will receive pre-determined responses just fine. Occasionally though an employee won't respond with exact character phrases, ("Yes" or "No" vs "Mno" or "es") - this breaks the regex because its not finding a match anymore.
I was looking to resolve the issue of not having pre-defined responses by making a user-form to send to the employees in replace of an email. Pursuant to this goal I've figured the best possible method would be check boxes/radio buttons. However, I'm not at all sure how to publish these forms to the employees of my office, furthermore, I am unsure how to get VBA to read the responses indicated by the user-form.
TL;DR:
I need a user-form or something similar to give to my employees so that they can ONLY answer with predetermined responses. How do I publish a user-form like that, and furthermore, how do I read for responses?
Any guidance is much appreciated.
Thank you!
The problem:
I've got an Excel file loaded up with data as a scheduling tool for the agency I work for. Its purpose is to send out an email, and make a new task item, for the employees of this company. Currently, it emails and will receive pre-determined responses just fine. Occasionally though an employee won't respond with exact character phrases, ("Yes" or "No" vs "Mno" or "es") - this breaks the regex because its not finding a match anymore.
I was looking to resolve the issue of not having pre-defined responses by making a user-form to send to the employees in replace of an email. Pursuant to this goal I've figured the best possible method would be check boxes/radio buttons. However, I'm not at all sure how to publish these forms to the employees of my office, furthermore, I am unsure how to get VBA to read the responses indicated by the user-form.
TL;DR:
I need a user-form or something similar to give to my employees so that they can ONLY answer with predetermined responses. How do I publish a user-form like that, and furthermore, how do I read for responses?
Any guidance is much appreciated.
Thank you!